Date value with time at Midnight
JithinApr 21 2009 — edited Apr 21 2009Hi All,
I have a requirement where I have to insert date into a column of datatype DATE. The requirement is to have the time value too. I ahve to insert dates with TIME as 000000hrs or 12:00:00 AM. But I am unable to do this. When ever i try, it inserts just the date. But if I try 12:00:01 AM, it inserts. Does anyone know why this is happening? Or how can I insert the desired values?
PS: the table already contains data and they have time in above mentioned format.
Thanks,
Jithin