# Create Unix Timestamps

**URL:** <https://community.cdata.com/t/create-unix-timestamps/840>\
**Category:** CData Virtuality \[Archived\]\
**Tags:** article, cdata-virtuality\
**Created:** [July 12, 2024, 4:48pm UTC](https://community.cdata.com/t/create-unix-timestamps/840 "2024-07-12T16:48:44Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![anonymous](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@anonymous](https://community.cdata.com/u/anonymous)\
**Post date:** [July 12, 2024, 4:48pm UTC](https://community.cdata.com/t/create-unix-timestamps/840/1 "2024-07-12T16:48:44Z")

</div>

Creating a Unix timestamp for the current timestamp:

| _`SELECT`&nbsp;`TIMESTAMPDIFF(SQL_TSI_SECOND, FROM_UNIXTIME(0), NOW());;`_ |
| --- |

Creating a Unix timestamp for any given date or timestamp:

| `SELECT`&nbsp;`TIMESTAMPDIFF(SQL_TSI_SECOND, FROM_UNIXTIME(0), mydateOrTimestamp);;` |
| --- |