RE: how to define date column in a table with only mm/dd/yyyy por

It's because in your output statement you have dbms_output.put_line (to_char(d11, 'dd-MON-yyyy HH:MM'));

Instead of MM you should have MI -- MM is printing out the month number which is 10.

Truncating a date gives you the date at midnight, so you should be getting 12:00 in the time information after truncation.

HTH,
Diana

-----Original Message-----
From: Rao, Maheswara [mailto:Maheswara.Rao_at_Sungardp3.com] Sent: Wednesday, November 01, 2000 12:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: how to define date column in a table with only mm/dd/yyyy por

QUESTION: The above program always is outputting the time portion as 12:10 in the time portion (example: 10-OCT-1999 12:10) Can anybody please explain to me the reason for this?

Thanks,

Rao

Maheswara.Rao_at_SunGardP3.com Received on Wed Nov 01 2000 - 13:50:07 CST