posted 19 years ago
I have 3 columns in a table say, A_DATE, A_TIME and A_DATETIME. The data type for all the columns is DATE.
Now I want to take the date part from A_DATE, time part from A_TIME, and insert those date & time values into A_DATETIME.
I could get the date & time part from the 2 columns using to_char funtion, but I don't know how to merge them and put it in to the third column. Any suggestions.
Thanks