Need Syntax help for timestamp YYYY-MM-DD-HH.MM.SS.ssssss!!

satish_nath · #1 (**permalink**) 04-17-04, 14:43

Thanks in adavance for looking into my post.

I need some help to write help to write a syntax in sql for Db2 that would give me a timestamp

of the following format...

YYYY-MM-DD-HH.MM.SS.ssssss

I need the 100th part of the second as i am trying to measure query execution time.

Will apprecite all suggestions, i am working Windows OS and Db2 8.1.3.

sathyaram_s · #2 (**permalink**) 04-17-04, 15:41

$ db2 "values(current timestamp,microsecond(current timestamp)) "

1 2
-------------------------- -----------
2004-04-17-21.04.21.746995 746995

1 record(s) selected.

HTH

Sathyaram

famudba · #3 (**permalink**) 04-18-04, 00:51

to handled timestamp in db2

use following functions

TIMESTAMP

TIMESTAMP(START_DATE)

TIMESTAMP_FORMAT

use above functions

Let me know, if any questions.

lekharaju Ennam
Certified Oracle8i & DB2 UDB DBA

satish_nath · #4 (**permalink**) 04-22-04, 03:00

Quote:

Originally posted by famudba
to handled timestamp in db2

use following functions

TIMESTAMP

TIMESTAMP(START_DATE)

TIMESTAMP_FORMAT

use above functions

Let me know, if any questions.

lekharaju Ennam
Certified Oracle8i & DB2 UDB DBA

Internet Services

Web Development

Digital Marketing

Consumer Tech