problem in date syntax
Posted: Wed Jan 05, 2005 6:06 am
using navicat i trying to retrive some application submitted between date
21st december 04 and 30th december 05
but its not working ?
can any one tell me what's the date format that can be used like: d
y or m:d:y etc.
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);
?>can any one tell me what's the date format that can be used like: d