If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Date & Time Question!!!

Hi all,

I have some weird problem, believe me! I have a table with a date column and bunch of other columns. After insert, i go and run a select statement and to_char the date like this, HH:MM:SS. It gives me the date right, but the time is always the same for each record that was inserted. The sysdate from dual gives the right time but I don't know why on insert the time is always the same. It seems like the clock has stopped.

Can someone tell me how to go about and fix this or where to find the time to set it right? Thanks.

I want to know, why my records always get the same time, even though they have been inserted at different times of the day? If I use to_char to get date with time, like in an above examples, the time part of Message_date column gives me the same time. Why? Thanks.