Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Problem with result set from a simple SQL Select

Re: Problem with result set from a simple SQL Select

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sun, 30 Jan 2005 01:15:30 GMT
Message-ID: <Xns95EDAF9144251SunnySD@68.6.19.6>


"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; A DATE datatype only provides granularity down to 1 second intervals.

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 Sat Jan 29 2005 - 19:15:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US