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.