Re: Date
Posted by:
Monika
Date: April 27, 2005 02:26AM
Hi,
how does your date (stored in the bigint(20) format) exactly look like?
I am not sure if this can help, but using the date format you could do it the following way:
...
AND v2.date_visit BETWEEN '2005-01-01' AND '2005-01-31'
or using the timestamp format:
AND v2.date_visit BETWEEN '2005-01-01%' AND '2005-01-31%'
Monika
Subject
Written By
Posted
Re: Date
April 27, 2005 02:26AM
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.