Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Posts
    19

    Unanswered: how can i get timestamp with millisconds

    hello
    i use db2 express c
    i want to get current timestamp with milliseconds

    when i write values (CURRENT TIMESTAMP)
    i get 22.10.2010 г. 09:55:47
    but i want the milliseconds too
    please help

  2. #2
    Join Date
    May 2009
    Posts
    508
    Provided Answers: 1
    josemourinho, what operating system and edition/version of DB2 are you using? Can you supply the exact statement you are using?

  3. #3
    Join Date
    Jan 2010
    Posts
    335
    > db2licm -l
    #Product name: "DB2 Express-C"
    License type: "Unwarranted"
    Expiry date: "Permanent"
    Product identifier: "db2expc"
    Version information: "9.7"
    Max number of CPUs: "2"
    Max amount of memory (GB): "2"


    > db2 "values (current timestamp)"

    1
    --------------------------
    2010-10-22-12.17.46.204349

    1 record(s) selected.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    On Windows you will only get:

    2010-10-22-12.17.46.204000

    Becasue of a limitation of the Windows operating system.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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