On Monday 25 June 2007 10:32, Mogens Melander wrote:
Looks like you have datetime fields makeing
2007-01-01 00:00:01 2007-01-01.
Or use
SELECT ... WHERE CONVERT(date,DATE)2007-01-01...
if 'date' is a DATETIME field.
Also using BETWEEN on date-ranges might help.
On Sun, June
Looks like you have datetime fields makeing
2007-01-01 00:00:01 2007-01-01.
Also using BETWEEN on date-ranges might help.
On Sun, June 24, 2007 02:13, Miguel Cardenas wrote:
Hello list
I found a little problem with an application am developing, in particular
creating reports by DATE
date(), date_format()
t
Miguel Cardenas írta:
Hello list
I found a little problem with an application am developing, in particular
creating reports by DATE ranges.
Examples:
select ... where date2007-01-01;
returns all records where date is greater (and equal inclusive) to 2007-01-01
Hello list
I found a little problem with an application am developing, in particular
creating reports by DATE ranges.
Examples:
select ... where date2007-01-01;
returns all records where date is greater (and equal inclusive) to 2007-01-01
select ... where date=2007-01-01;
returns all records