Re: SQL Concatenation

>>

I want to give the field a new MMDDYYYY while keeping the same hour and minute (HH24MI) from the date.
<<
When you set the value use to_date()

example:

UPDATE your.table SET your.date_field= TO_DATE('09/21/1999','MM/DD/YYYY')

It takes the first parameter (a text string) and converts it to a date. It uses the second argument to determine how to read/parse the text string. Received on Tue Sep 21 1999 - 12:42:36 CDT