Re: getting milliseconds from a DATE

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 09 May 2006 07:36:29 GMT
Message-ID: <1147160187.395377@proxy.dienste.wien.at>

Brian Peasland <oracle_dba_at_nospam.peasland.net> wrote:
> Robert Klemme wrote:

>> ianal Vista wrote:
>>> laredotornado_at_zipmail.com wrote in news:1147093983.362115.82810
>>> @y43g2000cwc.googlegroups.com:
>>>
>>>> Hello,
>>>>
>>>> I'm using Oracle 9i on Solaris.  How do I take a column of a DATE type
>>>> and convert it to milliseconds that have elapsed since Jan. 1, 1970, 12
>>>> AM?
>>>>
>>>> Thanks for any help, - Dave
>>>>
>>>>
>>>
>>> You do NOT get millisecond from DATE; must use TIMESTAMP
>> 
>> Hey, you could have been more helpful.  Why didn't you suggest to 
>> convert the DATE to TIMESTAMP and then extract ms?
>> 
>> SCNR
>> 
>>     robert

>
> Converting a DATE to a TIMESTAMP will not yield any millisecond values
> other than 0. You cannot obtain more precision out of a value in one
> datatype by converting it to a different datatype. For instance, you
> cannot convert an integer value 'X' to a floating point number and get
> more than 'X.0' out of it.

Let me propose 'the punchline conjecture':

No matter how simple a joke is, there will always be someone who doesn't get it, provided the audience is big enough.

Yours,
Laurenz Albe Received on Tue May 09 2006 - 02:36:29 CDT