Skip to main content
How-To

Create Unix Timestamps

  • July 12, 2024
  • 0 replies
  • 15 views
A
  • Anonymous

Creating a Unix timestamp for the current timestamp:

SELECT TIMESTAMPDIFF(SQL_TSI_SECOND, FROM_UNIXTIME(0), NOW());;

 

Creating a Unix timestamp for any given date or timestamp:

 

SELECT TIMESTAMPDIFF(SQL_TSI_SECOND, FROM_UNIXTIME(0), mydateOrTimestamp);;
    This topic has been closed for replies.
    State of AI Data Connectivity Report: 2026 Outlook
    Terms and ConditionsCookie settingsAccessibility statement