Re: Oracle Date Bug?

Hi Tim

I can't make my database (version 7.2.3) make the same stunt, and therefore I can't answer your question neither. But something stroke me anyway: Do take care of making TO_DATE conversions on dates. They are making and TO_CHAR conversion of your date field behind your back, and therefore you are doing (at least) two inadequate operations: First you make a conversion dependend on the standard format of the char-version of dates ('DD_MON_YY'?), and secondly your dates are truncated making the hh:mi parts 'disappear'.

Just a hint.

Micahel Ringbo, mri_at_dde.dk Received on Thu Jan 29 1998 - 00:00:00 CST