Hi

I have a date column in one of the table in oracle. The date value
stored is:
7/5/2006 2:11:00 PM.

I would like time to be updated to 6PM so that the date value will look
like:
7/5/2006 6:00:00 PM.

Can anybody please help.

Thanks
Pankaj

pankyrai wrote:
What have you tried so far, and what error message did you get?


/Lennart

Hi
I have tried this option:
1. Truncated the date to remove the timestamp value
2. Concatanated the timestamp value 6:00:00 PM and updated the column

This doesnt works as it updates in incorrect format.
Pankaj


Lennart wrote:

pankyrai wrote:

A quick fix would be to convert to string containing only the date using
TO_CHAR with the right format, then appending the string "6:00:00 PM"
and finally converting back to date again.

TO_CHAR is in the manual:

http://kortlink.dk/2uz4

I am sure there is a function for converting from string to date.

It's a hack, but it may just work. Otherwise take a closer look at the
date arithmetic functions:

http://kortlink.dk/2uz5

Regards,

Michael.
--
Which is more dangerous? TV guided missiles or TV guided families?
I am less likely to answer usenet postings by anonymous authors.
Visit my home page at http://michael.zedeler.dk/