Converting from CHAR to DATE datatype
As a time value, I used the CHAR datatype and need to convert to a DATE value while manipulating/computing. How do I use the DATE datatype instead?
In my example, my format mask is "MM/DD/YYYY." There are many format masks available and you can view them here:
The inverse of the TO_DATE function is the TO_CHAR function, which takes a DATE datatype value and converts it to a character string. Again, you have to specify the format mask of the output character string.