Title: Meddelelse
Rajesh,
SYSDATE is of datatype DATE (that's what the documentation says), i.e. it
contains century, year, month, day, hour, minute and second (without
decimals).
I have made a little test. FirstIdump a
SYSDATE to see the internal representation. Then Icreate a table with
] På vegne af Jesper
Haure NorrevangSendt: 30. januar 2004 08:24Til: Multiple
recipients of list ORACLE-LEmne: SV: Date Format:
Mystery
Rajesh,
SYSDATE is of datatype DATE (that's what the documentation says), i.e.
it contains century, year, month, day, hour, minute and second
Friday, January 30, 2004, 2:24:25 AM, Jesper Haure Norrevang ([EMAIL PROTECTED]) wrote:
JHN Certainly som conversion is going on here. This might be the reason why
JHN there has been confusion about 7 or 8 bytes in a DATE datatype.
That's really interesting, that switch between 7 and 8
bytes.
:
[EMAIL PROTECTED]Subject: Re: SV: Date Format: Mystery
.com