Convert BIGINT to TIMESTAMP

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Debabroto
    New Member
    • Jun 2012
    • 1

    Convert BIGINT to TIMESTAMP

    Hi,
    I'm able to convert TIMESTAMP value to BIGINT using the following command:

    select bigint(timestam p('2012-05-21 09:17:16.046982 ')) from sysibm.sysdummy 1

    Is it possible to convert a BIGINT value back to TIMESTAMP?

    Thanks in advance.
Working...