var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: CHAR(19) date field formats (was "SQL Statement help")
I have a table with the following fields:
ID [char(50]-- unique
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?
1. have you looked at the SUBSTRING and CONCAT functions?
2. why aren't they DATE datatypes instead of CHAR?