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 unix_timest
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')
TECTED]>
Sent: Wednesday, April 12, 2006 2:00 PM
Subject: Re: Select a value between dates.
>From: "Rhino" <[EMAIL PROTECTED]>
To: "H L" <[EMAIL PROTECTED]>,
Subject: Re: Select a value between dates. Date: Tue, 11 Apr 2006
16:35:15 -0400
- Original Me
- Original Message -
From: "H L" <[EMAIL PROTECTED]>
To:
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 b
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
