Reputation: 701

Getting timestamp using MySQL

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

Upvotes: 66

Answers (4)

Reputation: 20267

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();

Upvotes: 123

Reputation: 2335

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.

Upvotes: 13

Reputation: 213

just use NOW()

Upvotes: 3

Reputation: 181270

Select current_timestamp;

Upvotes: 7