|
|
|
Forum Member
 
Group: Forum Members
Last Login: 9/1/2008 3:06:30 AM
Posts: 27,
Visits: 145
|
|
The data type of DBQLogTbl's FirstRespTime and StartTime is 'TIMESTAMP' with format given as:
YYYY-MM-DDBHH:MI:SS.S(F)Z
If we have FirstRespTime like 2008-06-10 08:00:03.51
Here '51' means 51 = milliseconds i.e. 051ms OR 51 centiseconds = 510ms
A man with so large a head must have something in it ((Sherlock Holmes))
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: 2 days ago @ 5:32:31 PM
Posts: 298,
Visits: 362
|
|
|
The latter: 51 centiseconds = 510ms
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/1/2008 3:06:30 AM
Posts: 27,
Visits: 145
|
|
Thanks for the quick response.
Can you point out the Teradata documentation that mentions this. We need it to confirm our calculations and add official reference to it.
Thanks,
A man with so large a head must have something in it ((Sherlock Holmes))
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: 2 days ago @ 5:32:31 PM
Posts: 298,
Visits: 362
|
|
SQL Reference: Data Types and Literals
Your question was actually about Output FORMAT Phrases for a TIMESTAMP field, but you might also want to refer to the section documenting the TIMESTAMP Data Type to get the full explanation.
|
|
|
|