Hello,

I have a table with the following fields:

ID [char(50]-- unique
Created_DT [char(19)]
Updated_DT [char(19)]

Currently, the Created_DT contains date and time data as follows: '0000-00-00 00:00:00'. The Updated_DT contains dates in this format: '2004-02-16 12:45:03'.

What I want to do is take the date in the Updated_DT field and copy it into this format to the Created_DT field: '02/16/2004 12:00:00'.

Can someone tell help me with this?

Thanks

1. have you looked at the SUBSTRING and CONCAT functions?

2. why aren't they DATE datatypes instead of CHAR?