Time format of FirstRespTime (DBQLogTbl)

Database
Enthusiast

Time format of FirstRespTime (DBQLogTbl)

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
3 REPLIES
Teradata Employee

Re: Time format of FirstRespTime (DBQLogTbl)

The latter: 51 centiseconds = 510ms
Enthusiast

Re: Time format of FirstRespTime (DBQLogTbl)

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,
Teradata Employee

Re: Time format of FirstRespTime (DBQLogTbl)

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.