Jump to content

[SOLVED] date format


rugzo

Recommended Posts

Backup your database.

 

Add a new column to the table with a DATETIME data type. Use the mysql STR_TO_DATE() function in a single UPDATE query (a query without a WHERE clause will operate on all rows in the table) to populate the new column with the equivalent of the existing values.

 

Modify and test your existing scripts to use the new column.

 

Remove the old column.

Link to comment
https://forums.phpfreaks.com/topic/162153-solved-date-format/#findComment-855700
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.