Linux, FreeBSD, Juniper, Cisco / Network security articles and troubleshooting guides

FAQ

It is currently Tue Jun 06, 2023 8:36 am

ROOT ‹ Website Development and Databases ‹ Mysql ‹ Mysql> how to store select Zulu / UTC timestamp in database

Mysql Application & Query Optimization, Questions, Indexes, Bugs.

Post a reply

1 post • Page 1 of 1

Mysql> how to store select Zulu / UTC timestamp in database

« Previous topic | Next topic »

Author

Message

debuser

Post subject: Mysql> how to store select Zulu / UTC timestamp in database | Posted: Fri Dec 16, 2011 5:23 am

Joined: Thu Aug 06, 2009 2:48 am
Posts: 105

Mysql> how to store select Zulu / UTC timestamp in database

To obtain/store the current time in mysql, function "NOW()" needs to be used. But this takes into consideration the timezone set on the server.

To store the UTC time, in the same format, "UTC_TIMESTAMP()" function can be used:

Code:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2011-12-16 10:19:33 |
+---------------------+
1 row in set (0.00 sec)

mysql> select UTC_TIMESTAMP();
+---------------------+
| UTC_TIMESTAMP()     |
+---------------------+
| 2011-12-16 09:19:36 |
+---------------------+
1 row in set (0.05 sec)

P.S.: The column type for NOW() and UTC_TIMESTAMP() in mysql is "datetime".

			Tweet
Follow @IvordeCom

You might also be interested in:
Mysql convert unix timestamp to human readable format. How to calculate mysql time difference between unix timestamp column and now() format. Mysql> select records that have date/datetime column equal to today's date. MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13). Mysql: add column to table. Rename MySql table. MySql rename table. How to use a mysql stored procedure. Mysql: Cleaning binary logs. Mysql change column's default value.

Top

Post a reply

1 post • Page 1 of 1

Topics		Author	Replies	Views	Last post
Topics related to - "Mysql> how to store select Zulu / UTC timestamp in database"
	Mysql convert unix timestamp to human readable format	mandrei99	0	3632	Wed Jan 14, 2015 11:36 am mandrei99
	How to calculate mysql time difference between unix timestamp column and now() format	mandrei99	0	9585	Fri May 31, 2013 4:10 am mandrei99
	Mysql> select records that have date/datetime column equal to today's date	admin	0	3903	Tue Nov 22, 2011 9:40 am admin
	MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)	debuser	0	3146	Mon Feb 22, 2010 1:43 pm debuser
	Mysql: add column to table	debuser	1	4185	Fri Oct 08, 2010 1:38 am sonee4
	Rename MySql table	debuser	1	2309	Fri Oct 08, 2010 1:36 am sonee4
	MySql rename table	admin	2	2771	Mon Nov 28, 2011 3:39 am Darwin
	How to use a mysql stored procedure	debuser	1	2262	Tue Nov 22, 2011 1:23 am Darwin
	Mysql: Cleaning binary logs	debuser	1	2681	Tue May 18, 2010 9:45 am designeru
	Mysql change column's default value	debuser	0	2703	Thu Aug 12, 2010 3:43 am debuser

Who is online

Users browsing this forum: No registered users and 0 guests

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:

Channel list

ROOT ‹ Website Development and Databases ‹ Mysql

Delete all board cookies | The team | All times are UTC - 5 hours [ DST ]