MySQL Forums
Forum List  »  Newbie

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

Options: ReplyQuote


Subject
Written By
Posted
April 26, 2005 11:58PM
Re: Date
April 27, 2005 02:26AM
April 27, 2005 04:17AM
April 27, 2005 05:13AM
April 27, 2005 05:17AM
April 27, 2005 05:33AM
April 27, 2005 05:41AM
April 27, 2005 06:21AM
April 27, 2005 11:06PM
May 02, 2005 07:44AM


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.