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 add the custom code in Report?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
How to execute the cursor queries with "open" statements?
How do you delete a data source?
What is not null constraint?
What is the purpose of floor function?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What is star, snowflake and star flake schema? : sql server analysis services, ssas
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Can we use where clause in union?
Differentiate between sql temp table vs table variable?
Can we call future method from trigger?
Explain activity monitors
How to delete exactly duplicate records from a table?
How to change a login name in ms sql server?
