how to fetch the microsecond part in SQL Server

ashish tech · New User Joined: 05 Dec 2007 Posts: 7 Location: Delhi

In DB2 , we use MICROSECOND(Timestamp field) function to fetch miscrosecond part of a timestamp field.
What would be the similar function in SQL SERVER????

dbzTHEdinosauer · Posted: Tue Mar 04, 2008 6:09 pm

sql server comes with tons of documentation. in addition, there is the microsoft web site with several sub-sites concerned with sql.

try the microsoft urls provided in sql server documentation as well as every help function in the sql servier gui's.

abhishekmdwivedi · New User Joined: 22 Aug 2006 Posts: 95 Location: india

Hi ashish,

SQL Server 2005 allows you to store time till the accuracy of milliseconds only. If you want to fetch the milliseconds , you may use DATEPART function in SQL Server. (NO Microsecond Function)