how can i get timestamp with millisconds

josemourinho · #1 (**permalink**) 10-22-10, 03:56

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

Stealth_DBA · #2 (**permalink**) 10-22-10, 06:22

josemourinho, what operating system and edition/version of DB2 are you using? Can you supply the exact statement you are using?

nvk@vhv · #3 (**permalink**) 10-22-10, 06:23

> 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.

Marcus_A · #4 (**permalink**) 10-22-10, 10:34

On Windows you will only get:

2010-10-22-12.17.46.204000

Becasue of a limitation of the Windows operating system.

Internet Services

Web Development

Digital Marketing

Consumer Tech