Given a Date "03/13/2010", using that in a MYSQL Where Clause?
Posted
by nobosh
on Stack Overflow
See other posts from Stack Overflow
or by nobosh
Published on 2010-03-13T23:51:04Z
Indexed on
2010/03/13
23:55 UTC
Read the original article
Hit count: 125
I would like to pass a MYSQL query via Coldfusion the following date: 03/13/2010 So the query filters against it like so:
SELECT *
FROM myTable
WHERE dateAdded before or on 03/13/2010
I'd also like to be able to take 2 dates as ranges, from: 01/11/2000, to: 03/13/2010
SELECT *
FROMT myTable
WHERE dateAdded is ON or Between 01/11/2000 through 03/13/2010
thanks
© Stack Overflow or respective owner