Oracler Date function

[Clarice Doe]

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

[Shailesh Chandra]

I dont have database to test this but this works

INSERT INTO TABLE_NAME(A_DATETIME) 
SELECT TO_DATE((
(TO_CHAR(A_DATE,'DD/MM/YYYY') || ' ' || TO_CHAR(A_TIME,'HH24:MI:SS')),'DD/MM/YYYY HH24:MI:SS'
) as A_DATETIME FROM TABLE_NAME WHERE YOUR_CONDITION  

Shailesh

[Adeel Ansari]

You just want a query or you want it in your application. If its something your application needs to do then you had better do it in your code.