Timestamps in a Windows Environment

[rdpratti]

I am working with DB2 LUW after being away for a few years. Most of my
experinece is in the z/Os environment.

I am noticing the millisecond-only timestamps and trying to remember
if there is a way to get DB2 to insert the actual microseconds in
timestamps.

Thanks

- Roland

[Mark A]

"rdpratti" <ro*************@cox.netwrote in message
news:3f**********************************@f10g2000 hsf.googlegroups.com...

>I am working with DB2 LUW after being away for a few years. Most of my
experinece is in the z/Os environment.

I am noticing the millisecond-only timestamps and trying to remember
if there is a way to get DB2 to insert the actual microseconds in
timestamps.

Thanks

- Roland

You can get microseconds in Linux or UNIX, but not Windows.

But in DB2 you can use TIMESTAMP(GENERATE_UNIQUE()) to give a guaranteed
unique timestamp,even when inserting multiple rows within a single SQL
statement.

[Serge Rielau]

Mark A wrote:

"rdpratti" <ro*************@cox.netwrote in message
news:3f**********************************@f10g2000 hsf.googlegroups.com...

>I am working with DB2 LUW after being away for a few years. Most of my
experinece is in the z/Os environment.

I am noticing the millisecond-only timestamps and trying to remember
if there is a way to get DB2 to insert the actual microseconds in
timestamps.

You can get microseconds in Linux or UNIX, but not Windows.
But in DB2 you can use TIMESTAMP(GENERATE_UNIQUE()) to give a guaranteed
unique timestamp,even when inserting multiple rows within a single SQL
statement.

In other words. DB2 depends on the services of the OS. In Windows that's
pretty rough (hence the steps of 7ms when you do "ping").

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab