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?

Questions by sravan1   answers by sravan1

Showing Answers 1 - 1 of 1 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!

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.