All Forums Database
monisiqbal 119 posts Joined 07/09
10 Jun 2008
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)ZIf we have FirstRespTime like 2008-06-10 08:00:03.51Here '51' means 51 = milliseconds i.e. 051ms OR 51 centiseconds = 510ms

Fred 1096 posts Joined 08/04
10 Jun 2008

The latter: 51 centiseconds = 510ms

monisiqbal 119 posts Joined 07/09
10 Jun 2008

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,

Fred 1096 posts Joined 08/04
11 Jun 2008

SQL Reference: Data Types and LiteralsYour 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.

You must sign in to leave a comment.