Converting MYSQL timestamp to ISO-8601 without timzone offset

php mysql timestamp date-conversion
Jon Schatz picture Jon Schatz · Jul 11, 2011 · Viewed 7k times · Source

I'm trying to use timeago ( http://timeago.yarp.com/ ) and have found solutions for converting timestamps from MYSQL using php to ISO-8601. 

date('c',strtotime($TimeStamp));

This works fine except im getting the timezone offset at the end 

2011-07-10T08:46:50-**05:00**

what I want is 2011-07-10T08:46:50Z

Does anyone have a solution or know why i'm getting the timezone offset?

Answer

Marc B picture Marc B · Jul 11, 2011

You can do it directly in MySQL:

SELECT DATE_FORMAT(yourfield, '%Y-%m-%dT%H:%i:%s0Z')

There is a GET_FORMAT(datetime, 'iso') call as well, but that returns the format string for ISO 9075, which is not quite what you want. Since it doesn't do 8601 directly, you have to build the format string yourself.

Related questions

How to convert MySQL time to UNIX timestamp using PHP?

There are a lot of questions that ask about 'UNIX timestamp to MySQL time'. I needed the reversed way, yea... Any idea?

Read More
How to update MySql timestamp column to current timestamp on PHP?

I want to update the columns of data type timestamp manually through my PHP code. Can you please tell me how to do that?

Read More
Converting a carbon date to mysql timestamp.

I have a timestamp variable column in a mysql database. Trying to convert a carbon timestamp to something that I can input there, but Carbon::now() only returns a Carbon object and when I try to use the timestamp string …

Read More