InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 20 Nov 2008 11:09:17 GMT20http://www.teradata.com/teradataforum/Topic11795-9-1.aspxSQL 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.Wed, 11 Jun 2008 22:44:19 GMTFred Pluebellhttp://www.teradata.com/teradataforum/Topic11795-9-1.aspxThanks 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,Tue, 10 Jun 2008 12:03:21 GMTmonisiqbalhttp://www.teradata.com/teradataforum/Topic11795-9-1.aspxThe latter: 51 centiseconds = 510msTue, 10 Jun 2008 11:52:56 GMTFred Pluebellhttp://www.teradata.com/teradataforum/Topic11795-9-1.aspxThe 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 = 510msTue, 10 Jun 2008 11:44:53 GMTmonisiqbal