Timestamps in a Windows Environment

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rdpratti - 27 Jan 2008 00:03 GMT

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

Reply to this Message

Mark A - 27 Jan 2008 02:51 GMT

>I am working with DB2 LUW after being away for a few years. Most of my
> experinece is in the z/Os environment.
[quoted text clipped - 6 lines]
>
> - 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.

Reply to this Message

Serge Rielau - 27 Jan 2008 12:29 GMT

>> I am working with DB2 LUW after being away for a few years. Most of my
>> experinece is in the z/Os environment.
[quoted text clipped - 6 lines]
> 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

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message