problem in date syntax

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
itsmani1
Forum Regular
Posts: 791
Joined: Mon Sep 29, 2003 2:26 am
Location: Islamabad Pakistan
Contact:

problem in date syntax

Post 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.
User avatar
itsmani1
Forum Regular
Posts: 791
Joined: Mon Sep 29, 2003 2:26 am
Location: Islamabad Pakistan
Contact:

Post by itsmani1 »

remember i m using Navicat
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

http://dev.mysql.com/doc/mysql/en/DATETIME.html
read the first bullet point.

'2004-12-21'
Post Reply