DateFormat

[andy98]

Hi

I have the following

echo "Date of Complaint: $row[date_result]<br>";

date_result being a date/timestamp from a mySQL db table.

I have been trying unsuccessfully to perform a date format to get a UK DD-MM-YYYY and a Time.

Can anyone point me in the right direction?

Thanks in advance

 

[RobHudson]

Hi

Try using the MySQL DATE_FORMAT() function:

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

Good luck!
Rob

 

[andy98]

Hi Rob

I have been trying to use the date_format function but I guess my syntax must be incorrect. I'd appreciate if you have an example!

 

[RobHudson]

I don't use the TIMESTAMP type myself as I prefer just using the normal DATETIME.

But, this should work...
SELECT DATE_FORMAT(myCol, '%d-%c-%Y') FROM myTable

This works for me

 

[andy98]

How would i do the same in my output - having already queried the Database?

echo "Date of Complaint: $row[date_result]<br>";

 

[Olavxxx]

http://no2.php.net/date

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster