Jump to content

Recommended Posts

What's the best way to convert a date formatted as mm/dd/yyyy to a format that can be stored in mySQL (yyyy-mm-dd). The reason I want to convert is that when pulling the data back out of the database I need to sort it on date. If there is a better way to do this I am open to that as well.

 

Thanks for any and all replies.

Link to comment
https://forums.phpfreaks.com/topic/143787-date-converting-formats/
Share on other sites

Assuming that you have validated the original format and value (which you should always do for external data), use the mysql STR_TO_DATE function in your query - http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_str-to-date

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.