Why is that when I retrieve a date column with time format ('dd-mon-yyyy hh:mi:ss), I get the time for all the records as 12:00:00 ? How can is see the actual time in the date column?

Showing Answers 1 - 3 of 3 Answers

Ashok Nayak

Dec 19th, 2006

The problem arises because of the input date. You must not be having the timestamp in your input. So when you retrieve it into the date format "DD_MON_YYYY hh:mm:ss", what happens is that a typecast is done and the default value for the timestamp is populated. You can't populate values which you never had in the first place!