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: 127

Filed under:
|
|
|

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

Related posts about mysql

Related posts about datetime