Date Format Problem

[job1]

Hi

In my report I need to display a timestamp field. I have to show it with nanoseconds i.e dd/mm/yy HH.mm.ss.nnnn(01/01/2005 11:09:23.1234).

Currently I am getting dd/mm/yy HH.mm.ss and not able to get the nanoseconds. Have anyone help me to solve this problem.

-TIA

 

[skrandel]

I do not believe this is possible. Do databases store it with nanoseconds.

Steve Krandel
VERITAS Software

 

[xlbo]

Don't know of any database that has a defined date/time field to store data at nanosecond level....

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[dbomrrsm]

You could get the DB to hold data like this but not in a date (oracle) datetime (SQL Server) format.

It would have to be held as varchar2 or varchar.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[dbomrrsm]

sorry talking rubbish SQL Server holds time down to fractions of seconds:

select getdate()

2005-02-18 16:06:01.937

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[xlbo]

But not nanoseconds - you need another factor of 10 for that....

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[skrandel]

Even though SQL servers stores it, I do not believe BO will retrieve it. Build that same object in BO, then try to format it to more digits. I bet it won't work.

Steve Krandel
VERITAS Software

 

[BrianTyler]

DB2 UDB on AIX certainly goes down to a low level. I have never managed to make BO v5 process this properly. I believe you can fiddle with Input-Date-Format in the SBO file to change the options but I have never had any success.


M80 CBSDWHPB2DWHP >db2 "values current timestamp"

1
--------------------------
2005-02-21-13.44.28.311487

1 record(s) selected.