<div>
<br />
Timestampdiff() used to have an issue where it produced some really, really bad answers. &nbsp;Still, you can calculate it easily.<br />
<br />
<br />
Kent<br />
<br />

<pre><code class="code-1 nolinks" id="code-123635"><span>  SELECT seconds(current timestamp) - seconds (timestamp('1970-01-01-00.00.00.000000')) </span>
<span>  FROM sysibm.sysdummy1;</span>
</code></pre>
</div>


<div>
<br />
Sorry momi,<br />
<br />
I didn't see your second approach at the bottom of your post.<br />
<br />
Kent<br />

</div>


<div>
<div class="content wysiwyg-content">
how can i get the current time in seconds in db2,,, unix epoch.
</div>
</div>


how can i get the current time in seconds in db2,,, unix epoch.

Get current time, in seconds,,, (unix epoch) in db2

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.