Date string format

[aeroswat]

The way that dates are stored in MySQL are yyyy-mm-dd. I was wondering if there is an easy way to change that to mm/dd/yyyy or would I have to pick it apart?

[.josh]

you can use date_format() in your query or you can use strtotime date and/or mktime in php (combo of one or more of those).

[aeroswat]

you can use date_format() in your query or you can use strtotime date and/or mktime in php (combo of one or more of those).

 

Thanks. Looks like I am going to have to pick it apart cause I really don't want a timestamp. I just want the formatted date. I will have to use those with a substr

[aeroswat]

For a solution to anyone with the same problem what I did is this:

 

date('m/d/Y', strtotime($date))

[PFMaBiSmAd]

The mysql date_format() function is at least a hundred times faster then using php code (comparing the incremental increase in the time for the query with a date_format() with the time it takes php code to do the same amount of work.) You are already executing a query to retrieve the data, why not get the database engine to give you the data in the format that you want it?

[aeroswat]

The mysql date_format() function is at least a hundred times faster then using php code (comparing the incremental increase in the time for the query with a date_format() with the time it takes php code to do the same amount of work.) You are already executing a query to retrieve the data, why not get the database engine to give you the data in the format that you want it?

 

Ok i'll try that out.

[aeroswat]

Would I still access the variable in the same way? And if I am getting all the fields would I do something like this:

 

SELECT *, DATE_FORMAT(DATE, '%m/%d/%Y') etc...

[.josh]

create an alias for it.

 

SELECT *, DATE_FORMAT(DATE, '%m/%d/%Y') as blah etc...

 

and then $row['blah']  (assumed mysql_fetch_assoc or _array)

[gerardcorr]

You need to do it using the date_format mysql function. Here is a website that does it for you http://www.mysqlformatdate.com