bsamson Posted January 21, 2008 Share Posted January 21, 2008 Hello. I have a DATE field in MySQL. So I have a date formated like: 2008/01/22 I have this line @ the beginning of my script: $day2 = date("Y/m/d", time()-(86400 * 2)); Which of course gets the date from 2 days ago. Now I am trying to create another variable w/ it formated like: 01/22/2008. So ... I want to take ... $day2 = "2008/01/19" and make $formated-day2="01/19/2008" How can I do this? I need $day2 to maintain that format for the DB query I am doing elsewhere in the script. Any help would be greatly appreciated! Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/87097-how-to-format-a-date-in-php/ Share on other sites More sharing options...
p2grace Posted January 21, 2008 Share Posted January 21, 2008 You could explode it into an array. $day2 = "2008/01/19" $arr = explode("/",$day2); $formated = $arr[1]."/".$arr[2]."/".$arr[0]; // should yield 01/19/2008 Quote Link to comment https://forums.phpfreaks.com/topic/87097-how-to-format-a-date-in-php/#findComment-445454 Share on other sites More sharing options...
Daniel0 Posted January 21, 2008 Share Posted January 21, 2008 Alternately you could use strtotime() to make a formatted date into a UNIX timestamp and then use date() to format it accordingly to your needs. Quote Link to comment https://forums.phpfreaks.com/topic/87097-how-to-format-a-date-in-php/#findComment-445581 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.