Getting timestamp using MySQL

Question

How can I get the current timestamp using a mysql query?

Brad Koch · Answer 1 · 2016-05-03T21:34:55.293

119

Depends on which kind you're looking for.

The current integer Unix Timestamp (1350517005) can be retrieved like so:

SELECT UNIX_TIMESTAMP();

MySQL often displays timestamps as date/time strings. To get one of those, these are your basic options (from the MySQL Date & Time reference):

SELECT CURRENT_TIMESTAMP;
SELECT CURRENT_TIMESTAMP();
SELECT NOW();

edited May 03 '16 at 21:34

answered Oct 17 '12 at 23:45

Brad Koch

How do I change this? It is set to UTC I want to change it to IST +0530. I have root access to Ubuntu – Donnie Ashok Jan 16 '18 at 07:54
That's worth a new question, but the short answer is that you're probably best off either leaving the server at UTC and using [`CONVERT_TZ`](https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_convert-tz), or setting the default time zone using one of the [methods in the docs](https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html). – Brad Koch Jan 16 '18 at 14:31

score 13 · Answer 2 · edited May 26 '14 at 20:23

13

CURRENT_TIMESTAMP is standard SQL and works on SQL server, Oracle, MySQL, etc. You should try to keep to the standard as much as you can.

edited May 26 '14 at 20:23

Brad Koch

answered Feb 21 '13 at 17:08

Alex

3

inserting CURRENT_TIMESTAMP in a bigint will not store a unix timestamp – Alain Tiemblo Sep 28 '16 at 13:47

score 7 · Answer 3 · answered Dec 10 '10 at 16:57

7

Select current_timestamp;

answered Dec 10 '10 at 16:57

Pablo Santa Cruz

score 3 · Answer 4 · answered Dec 10 '10 at 16:58

3

just use NOW()

answered Dec 10 '10 at 16:58

Proteux

4 Answers4