date_format in mysql select statement

Question

Hi,

I have date stored in my mysql table as "2010-01-01 01:01:01"

but when i query the date with date_format command like

DATE_FORMAT( date_created, '%%m-%%d-%%y (%%h:%%i %%p)' ) as cdate

I am getting a converted date basing on mysql system timezone.. i.e. few hours difference..

for that i have used query :

"SET GLOBAL time_zone = '+5:30'"
"SET SESSION time_zone = '+5:30'"

But still mysql query delivering converted date... i want to get the date exactly which is stored in that table without adding/subtracting timezone differencess.

Please help. I am really stuck.

Answer 1

SET SESSION time_zone = SYSTEM;

or

SET SESSION time_zone = '+0:0'; -- for UTC time if server TZ is set correctly.