Robert Klemme wrote:
> ianal Vista wrote:
>> laredotornado@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.

HTH,
Brian


--
================================================== =================

Brian Peasland
oracle_dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown