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 Quote 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. Quote 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 Quote 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" ? Quote Link to comment https://forums.phpfreaks.com/topic/98880-php-date-problem/#findComment-505976 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.