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
Thanks for your help.