Re: Date
Bharati Raul wrote:
> I want to compare the date field i.e "v2.date_visit", which is in bigint(20) format in
> the following query.
Why aren't you using TIMESTAMP or DATETIME column types?
> Say I want to extract the record whose visit date is between 1st Jan 2005 to
> 31st Jan 2005.
1st Jan 2005 -> 20050101000000
31st Jan 2005 -> 20050131235959
So
SELECT ... FROM foo where ts BETWEEN 20050101000000 AND 20050131235959
should work.
--
felix
Subject
Written By
Posted
Re: Date
April 27, 2005 05:33AM
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.