Re: datetime vs date,time
KimSeong Loh Wrote:
-------------------------------------------------------
> Date is 3 bytes.
> Time is 3 bytes.
> Datetime is 8 bytes.
>
> The smaller size could have reduce the disk io and
> the amount of memory required to do sorting.
>
> Did you wrongly use order by field2,field2 desc?
> field2 twice?
yes mistake typing, order by field1,field2
Subject
Views
Written By
Posted
9127
May 16, 2007 02:31AM
3575
May 17, 2007 05:07AM
3092
May 17, 2007 06:08AM
Re: datetime vs date,time
2986
May 17, 2007 10:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.