Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

TO_DATE(x[, format]) converts the x string to a datetime

You can provide an optional format string to indicate the format of x. The default format is DD-MON-YYYY or DD-MON-YY.