Try to search your question here, if you can't find : Ask Any Question Now ?

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

HomeCategory: stackoverflowHow to print GETDATE() in SQL Server with milliseconds in time?
Avatargaurav asked 2 weeks ago

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.

1 Answers
Best Answer
Avatarnaveen answered 2 weeks ago
Your Answer

7 + 0 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com