rsammy Posted March 31, 2008 Share Posted March 31, 2008 why does this code not work for me? $dcn_dov = date("n/j/y",$datequery); here, $datequery is todays date - i got this by querying the database for todays date. while todays date is 2008-03-31, when i try to format it the way i want it, it gives me 12/31/69. i thot n is used to display the month without leading zeros and y is used to display year in 2 digits help pleeeease Link to comment https://forums.phpfreaks.com/topic/98880-php-date-problem/ Share on other sites More sharing options...
metrostars Posted March 31, 2008 Share Posted March 31, 2008 try using strtotime($datequery) in place of just the string query. Edit & PS: You could also use DATE_FORMAT(NOW(), '%c/%e/%y') AS `todaysdate` in the mysql query so it is already in the right format. Link to comment https://forums.phpfreaks.com/topic/98880-php-date-problem/#findComment-505964 Share on other sites More sharing options...
rsammy Posted March 31, 2008 Author Share Posted March 31, 2008 thanx metro! that worked Link to comment https://forums.phpfreaks.com/topic/98880-php-date-problem/#findComment-505973 Share on other sites More sharing options...
rsammy Posted March 31, 2008 Author Share Posted March 31, 2008 why am i unable to change the status to "topic solved" ? Link to comment https://forums.phpfreaks.com/topic/98880-php-date-problem/#findComment-505976 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.