How to save time as UTC time in php/mysql?

Question

I use

date_default_timezone_set($_SESSION['time_zone']);

to set a users timezone on a page, I am wanting to know, how do I save current time to mysql in php with the current UTC date and time? Also should I be storing it as a timestamp?

My existing site used datetime fields and when I saved a new item to mysql I could just use now() in the php part making the insert or update query

Joe Holloway · Accepted Answer · 2009-12-31 23:43:00Z

2

Here are the relevant MySQL functions if you'd rather do it in your SQL:

SELECT UTC_TIMESTAMP(), UTC_DATE(), UTC_TIME();

UTC_TIMESTAMP() is what you're looking for if you want to store as a DATETIME field

answered Dec 31, 2009 at 23:43

Joe Holloway

29k15 gold badges86 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matěj G. · Accepted Answer · 2009-12-31 23:55:34Z

1

gmdate('U'); outputs the GMT/UTC timestamp of the specified timestamp based on the current timezone.

See more information on the PHP Manual page

edited Dec 31, 2009 at 23:55

answered Dec 31, 2009 at 20:05

Matěj G.

3,1151 gold badge28 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to save time as UTC time in php/mysql?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related