Re: Problem with result set from a simple SQL Select
Date: Sun, 30 Jan 2005 01:15:30 GMT
Message-ID: <Xns95EDAF9144251SunnySD_at_68.6.19.6>
[Quoted] "lennyw" <lwintfeld_at_libertycorner.net> wrote in news:1107044827.490858.34650_at_f14g2000cwb.googlegroups.com:
> Thanks for your reply. I'll add the TO_DATE to the query when I get
> back to work on Monday. You're right that a DATE type is not a string;
> it's an integral multiple of milliseconds since <some epoch>.
SELECT TO_CHAR
(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW"
FROM DUAL;
[Quoted] A DATE datatype only provides granularity down to 1 second intervals.
[Quoted] Oracle can store dates in the Julian era, ranging from January 1, 4712 BCE through December 31, 4712 CE (Common Era, or 'AD'). Unless BCE ('BC' in the format mask) is specifically used, CE date entries are the default. Received on Sun Jan 30 2005 - 02:15:30 CET