Re: problem with date and to_char

Ted,

> January 08, 2002 04:01
>
> why is this 04:01?
>
> Every time I do this I get the very first date (that no longer
> exists).
> Why do I get different results. I expect 'select *' is the base and
> everything else is a varient.

You're going to have to be clearer about the source of your confusion.
I've read your e-mail twice, and I just can't see what the problem is.
The results that you get are exactly according to the documentation.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco