On Wed, 13 Jul 2005 00:34:15 -0400, wrote:
Scott Haneda wrote:
I can not get this to work how I would think it should be formatted:
SELECT IF(NOW() BETWEEN sale_start AND sale_end, 'yes', 'no')
That seems to work just fine
It should, as that is correct syntax, as documented in the manual
zzapper wrote:
On Wed, 13 Jul 2005 00:34:15 -0400, wrote:
Scott Haneda wrote:
I can not get this to work how I would think it should be formatted:
SELECT IF(NOW() BETWEEN sale_start AND sale_end, 'yes', 'no')
That seems to work just fine
It should, as that is correct syntax, as
I can not get this to work how I would think it should be formatted:
SELECT IF(NOW() BETWEEN sale_start AND sale_end, 'yes', 'no')
That seems to work just fine
However, I was under the impression that BETWEEN was to be formatted
BETWEEN(va1, v2)
Which leads me to:
SELECT IF(NOW()
Scott Haneda wrote:
I can not get this to work how I would think it should be formatted:
SELECT IF(NOW() BETWEEN sale_start AND sale_end, 'yes', 'no')
That seems to work just fine
It should, as that is correct syntax, as documented in the manual