Date Comarision

[kumarrana]

It is kidda stupid to ask. I used a hard coded time format "July 04, 2007" stored on MySQL. Now I want to display a message a week from that date. Anybody know any easy solution.

[DarkWater]

Yeah, don't hardcode dates into MySQL.  Change it to a DATE column and write a PHP script that loops through every row and fixes them. >_>

[Barand]

This will convert your string to a mysql DATE type and add seven days.

$sql = "SELECT STR_TO DATE(datecol, '%M $d, %Y') + INTERVAL 7 DAY"; 			

 

But as DW said, better to change to mysql DATE type (format YYYY-MM-DD) as most other formats, such as yours, are of zero use as DB dates. You can use that same STR_TO DATE function to update your table.

[kumarrana]

Thanks, Darak and Dw for the idea.

[PFMaBiSmAd]

It is not necessary to use any php code to fix date columns.

 

1) Backup your database.

 

2) Alter your table to add a new column of the correct type.

 

3) Run an UPDATE query (using the mysql STR_TO DATE() function) to populate the new column with the equivalent values from the existing column.

 

4) Modify and test your code to correctly use the new column.

 

5) Remove the old column.