, 2006 2:00 PM
Subject: Re: Select a value between dates.
From: Rhino [EMAIL PROTECTED]
To: H L [EMAIL PROTECTED],mysql@lists.mysql.com
Subject: Re: Select a value between dates. Date: Tue, 11 Apr 2006
16:35:15 -0400
- Original Message - From: H L [EMAIL PROTECTED]
To: mysql
This brings up a question I was asked...
Which is more efficient?
Select . where date between '-mm-dd hh:mm:ss' and '-mm-dd
hh:mm:ss'
Or
Select . where unix_timestamp(date) between
unix_timestamp('-mm-dd hh:mm:ss') and unix_timestamp('-mm-dd
hh:mm:ss')
George Law wrote:
This brings up a question I was asked...
Which is more efficient?
Select . where date between '-mm-dd hh:mm:ss' and '-mm-dd
hh:mm:ss'
This one.
Or
Select . where unix_timestamp(date) between
unix_timestamp('-mm-dd hh:mm:ss') and
I am far from an mysql expert... but is there a way to select between dates
in a table and check if a value exists in all fields between dates. If one
day between those dates cannot be booked i dont want to get it in my SUM
resultset.
I want to calculate Sum between those dates and i one idea
- Original Message -
From: H L [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, April 11, 2006 4:05 PM
Subject: Select a value between dates.
I am far from an mysql expert... but is there a way to select between dates
in a table and check if a value exists in all fields