Brian Peasland <oracle_dba@nospam.peasland.net> wrote:
> 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.

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