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! 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 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. 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
Archived
This topic is now archived and is closed to further replies.