date format

[Anon]

Hi Guys,
If i have a UNIX time_stamp value in a database, lets say 1019256292, how do i convert this to mm/dd/yyyy using PHP of course?

[Anon]

use the date() function.

[van__]

well you could hang with Diego and call the PHP date() function over and over and over again.

...or...

Have the database do it for you.

$sql = "SELECT DATE_FORMAT(date_field_name,/%m/%d/%Y') as fDate FROM myTable";

now just call fDate from your MySQL result set.

[van__]

oops made a typo..

$sql = "SELECT DATE_FORMAT(date_field_name,'%m/%d/%Y') as fDate FROM myTable";

should work ok