CODEWITHSUNDEEP
mysqltimestamp
Petruza
Petruza

Reputation: 12276

MySQL: how to get an actual TimeStamp? literally the amount of seconds since 1970-01-01 UTC

A MySQL timestamp field is written and read as 'yyyy-MM-dd hh:mm:ss', how can I get the actual amount of seconds since 1970-01-01 UTC?

Upvotes: 0

Views: 3453

Answers (2)

Pekka
Pekka

Reputation: 449813

Use UNIX_TIMESTAMP.

If called with no argument, returns a Unix timestamp (seconds since '1970-01-01 00:00:00' UTC) as an unsigned integer. If UNIX_TIMESTAMP() is called with a date argument, it returns the value of the argument as seconds since '1970-01-01 00:00:00' UTC. date may be a DATE string, a DATETIME string, a TIMESTAMP, or a number in the format YYMMDD or YYYYMMDD.

Upvotes: 7

JR Boyens
JR Boyens

Reputation: 287

SELECT UNIX_TIMESTAMP('2007-11-30 10:30:19');

or

SELECT UNIX_TIMESTAMP(fieldGoesHere) FROM blah WHERE foo = 1;

Upvotes: 3

Related Questions