Need HELP to convert a char value to data value. PLEASE

Posted by rogeliolt on 03-Jul-2015 14:48


I have a little problem, exist a table with fields type character, but in this fields exist information of dates.

We are migrating this information in a new table, but we don't know how convert this char information in date.

Please help me.


All Replies

Posted by TheMadDBA on 03-Jul-2015 14:54

Documentation link:

DISPLAY DATE(table.column).

Assuming your character column is actually stored in your local date format.

This thread is closed