Page 1 of 1

problem in date syntax

Posted: Wed Jan 05, 2005 6:06 am
by itsmani1
using navicat i trying to retrive some application submitted between date
21st december 04 and 30th december 05

Code: Select all

<?php


$strqr ="select appdate from tbl_app where appdate between __ and __";
$re = mysql_query($strqr);
?>
but its not working ?
can any one tell me what's the date format that can be used like: d:m:y or m:d:y etc.

Posted: Wed Jan 05, 2005 6:29 am
by itsmani1
remember i m using Navicat

Posted: Wed Jan 05, 2005 9:17 am
by feyd
http://dev.mysql.com/doc/mysql/en/DATETIME.html
read the first bullet point.

'2004-12-21'