Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009
    Posts
    11

    Unanswered: How to convert Date

    According to a quick google, the JMSTimestamp is:
    The value is in the format of a normal millis absolute time value in the Java programming language, which is the difference, measured in milliseconds, between the a given time and midnight, January 1, 1970 UTC.

    SET @MiliSeconds = 1241091011533
    SELECT DATEADD(MS, @MiliSeconds % 1000, DATEADD(SECOND, @MiliSeconds / 1000, '19700101'))

    How to use this in DB2 above command is for Microsoft SQL Server only.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    You may want to post this in the DB2 forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •