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 is a cache in ssrs?
What is data block and how to define data block size?
What is row-level compre?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
How to get a list of columns using the "sys.columns" view in ms sql server?
How can you stop stored procedures from recompiling?
What are the essential components of sql server service broker?
What are the general features of sql server management studio? : sql server management studio
How to locate and take substrings with charindex() and substring() functions?
What is sql server database?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Can we use having clause without group by?
What is default constraint in ms sql server?
How to convert a unicode strings to non-unicode strings?
Define normalisation?