Skip to content
Related Articles

Related Articles

Improve Article

UNIX_TIMESTAMP() function in MySQL

  • Last Updated : 22 Dec, 2020
Geek Week

UNIX_TIMESTAMP() :
This function in MySQL helps to return a Unix timestamp. We can define a Unix timestamp as the number of seconds that have passed since ‘1970-01-01 00:00:00’UTC. Even if you pass the current date/time or another specified date/time, the function will return a Unix timestamp based on that.

Syntax :

UNIX_TIMESTAMP()
UNIX_TIMESTAMP(date)

Parameters :
It will accept only one argument.

  • date –
    A date value which can be DATE, DATETIME, TIMESTAMP, or a number in ‘YYYYMMDD’ or ‘YYMMDD’ format.

Return :

  • If no parameter is passed, the function will return a Unix timestamp in seconds since ‘1970-01-01 00:00:00’ UTC in form of an unsigned integer.
  • But if the date parameter is passed, the function will return the value of parameter in form of an unsigned integer in seconds since ‘1970-01-01 00:00:00’ UTC.

Example-1 :
Working of UNIX_TIMESTAMP() using Current date/time.



SELECT UNIX_TIMESTAMP() 
As TimeStamp; 

Output :

TimeStamp
1606925233

Example-2 :
Working of UNIX_TIMESTAMP() using date value ‘1999-01-22’.

SELECT UNIX_TIMESTAMP('1999-01-22') 
As TimeStamp; 

Output :

TimeStamp
916988400

Example-3 :
Working of UNIX_TIMESTAMP() using DateTime value ‘2020-10-17 02:35:43’.

SELECT UNIX_TIMESTAMP('2020-10-17 02:35:43') 
As TimeStamp; 

Output :

TimeStamp
1602923743

Example-4 :
Working of UNIX_TIMESTAMP() using DateTime value along with fractional seconds ‘2020-10-17 02:35:43.12345’.

SELECT UNIX_TIMESTAMP('2020-10-17 02:35:43.12345') 
As TimeStamp; 

Output :

TimeStamp
1602923743.12345

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

My Personal Notes arrow_drop_up
Recommended Articles
Page :