Answer Posted / suraj
Selvaraj, You are wrong. I tested it.
Please, look at the output of these below queries.
'GetUTCDate' results in time difference which means it will
not give you the exact result as 'GETDATE()'.
SELECT GETUTCDATE()
-----------------------
2009-11-30 22:15:15.243
SELECT GETDATE()
-----------------------
2009-11-30 16:15:15.243
SELECT CURRENT_TIMESTAMP
-----------------------
2009-11-30 16:15:15.243
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the joins in sql server? : sql server database administration
Explain a differential backup?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
Mention a few common trace flags used with sql server?
What are acid properties of transaction?
In which format does an image save in SQL Server database ?
Differentiate sql server reporting services vs. Crystal reports?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How to see existing views in ms sql server?
Define tempdb database?
Do you know what is sql service broker?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What are the built in functions in sql server?
What is schemabinding a view?
What is the server name in sql server?