How to print GETDATE() in SQL Server with milliseconds in time?

sql sql-server sql-server-2008 datetime getdate
Ramakrishnan picture Ramakrishnan · Mar 15, 2011 · Viewed 199.2k times · Source

I want to print GETDATE() in SQL Server 2008, I need the time with milliseconds (this is for debugging purpose - to find sp's execution time )

I find this Difference

  • SELECT GETDATE() returns 2011-03-15 18:43:44.100
  • print GETDATE() returns Mar 15 2011 6:44PM

I think SQL Server automatically typecast in print functionality.

I need to print the date like this 2011-03-15 18:43:44.100

Thanks for your help.

Answer

Adam Robinson picture Adam Robinson · Mar 15, 2011

First, you should probably use SYSDATETIME() if you're looking for more precision.

To format your data with milliseconds, try CONVERT(varchar, SYSDATETIME(), 121).

For other formats, check out the MSDN page on CAST and CONVERT.

Related questions

How can I select the first day of a month in SQL?

I just need to select the first day of the month of a given datetime variable. I know it's quite easy to do using this kind of code: select CAST(CAST(YEAR(@mydate) AS VARCHAR(4)) + '/' + CAST(MONTH(@mydate) …

Read More
Getting the current date in SQL Server?

How can I get the current date in MS-SQL Server 2008 R2? The format of the column in my database is DATETIME and dates are stored in the following format: +++++++++++++ Vrdate ++++++++++ | | | 2012-11-18 00:00:00.000 | | 2012-11-19 00:00:00.000 | | 2013-11-18 00:00:00.000 | | 2012-12-01 00:00:00.000 | | 2010-10-09 00:00:00.000 | | 2012…

Read More
Calculate time difference in minutes in SQL Server

I need the time difference between two times in minutes. I am having the start time and end time as shown below: start time | End Time 11:15:00 | 13:15:00 10:45:00 | 18:59:00 I need the output for first row as 45,60,15 which corresponds to the time difference …

Read More