[SOLVED] SQL sorting by date

[drummer101]

Well I didn't do such a great job designing one of my code snippets, and ended up storing the date in plain text, e.g. 1/10/2008, what would be the best way to store dates in the DB so they are easy to manipulate.

 

I've created a new field on the table, type = date and I'm curious what I would use on the PHP side to properly format the input for the database.

 

the date type is formatted yyyy-mm-dd, would date(Y-m-d) be the correct way to go about this or is there an easier way? Once stored, would explode() be the optimal way to get the date back into a mm-dd-yyyy format?

[rajivgonsalves]

you can order by str_to_date(datefield,'%m/%d/%Y');

 

assuming that your date format is mm/dd/yyyy

[priti]

Well I didn't do such a great job designing one of my code snippets, and ended up storing the date in plain text, e.g. 1/10/2008, what would be the best way to store dates in the DB so they are easy to manipulate.

 

I've created a new field on the table, type = date and I'm curious what I would use on the PHP side to properly format the input for the database.

 

the date type is formatted yyyy-mm-dd, would date(Y-m-d) be the correct way to go about this or is there an easier way? Once stored, would explode() be the optimal way to get the date back into a mm-dd-yyyy format?

Hi drummer,

 

First thing when ever you are saving your date use the data type Date or datetime.And i will suggest you to use date_format() function of mysql while saving the date in the required format or while retrieve.

 

Regards

[drummer101]

Awesome, thank you both so much.