Date and timestamp comparision

From: Sylvester, Peter A. <peters_at_mitre.org>
Date: Wed, 4 Jun 2008 19:10:27 -0400
Message-ID: <2BA3384D0B8F9A41A906D1FFC25EB35D02887DBE@IMCSRV3.MITRE.ORG>

This is purely conjecture, but you could try creating a function based index on to_timstamp(creation_date).

--Peter

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 04 2008 - 18:10:27 CDT

This message: [ Message body ]
Next message: Jack van Zanen: "Re: trying to use sqlplus to do a build and making it dynamic"
Previous message: Jared Still: "Re: trying to use sqlplus to do a build and making it dynamic"
Next in thread: David Aldridge: "Re: Date and timestamp comparision"
Maybe reply: David Aldridge: "Re: Date and timestamp comparision"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message