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

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

Hi.

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.

Thanks.

All Replies

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

Documentation link:

community.progress.com/.../1329.openedge-product-documentation-overview.aspx

DISPLAY DATE(table.column).

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

This thread is closed