• ⌂ Date & Time
• Functions
  • ADDDATE()
  • ADDTIME()
  • CURDATE()
  • CURRENT_DATE()
  • CURRENT_TIME()
  • CURRENT_TIMESTAMP()
  • CURTIME()
  • DATE()
  • DATEDIFF()
  • DATE_ADD()
  • DATE_FORMAT()
  • DATE_SUB()
  • DAY()
  • DAYOFMONTH()
  • DAYOFYEAR()
  • HOUR()
  • MICROSECOND()
  • MINUTE()
  • MONTH()
  • NOW()
  • SECOND()
  • TIME()
  • TIMEDIFF()
  • UNIX_TIMESTAMP()
  • WEEK()
  • WEEKDAY()
  • YEAR()

UNIX_TIMESTAMP()

Return the date or timestamp as an unsigned integer in standard UNIX time format (seconds since '1970-01-01 00:00:00' UTC).

Prototype

integer UNIX_TIMESTAMP(mixed $timestamp)

Parameters

• timestamp - A date ("YYYY-MM-DD") or timestamp ("YYYY-MM-DD HH:MM:SS").

Return

Unsigned integer in standard UNIX time format (seconds since '1970-01-01 00:00:00' UTC), or NULL if there is an error, such as an invalid timestamp.

Example

SELECT OID, UNIX_TIMESTAMP(META(LastModified)) AS Modified FROM User

• < TIMEDIFF()
• WEEK() >