Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to use subqueries in the from clause in ms sql server?
Explain primary key and foreign key constraints?
What is the difference between writing data to mirrored drives versus raid5 drives
What is difference between rollback immediate and with no_wait during alter database?
What is SQL Azure Data sync?
Can we join two tables without primary key?
What is molap and its advantage? : sql server analysis services, ssas
What are the approximate numeric data types?
Explain what is lock escalation?
How to delete duplicate rows in sql server?
Which sql server is best?
Why we use trigger in sql server with example?
How to access the inserted record of an event?
How many types of objects are there?
How to delete duplicate records based on single column from a table?
