Answer Posted / selvaraj.v
First you Clearly Learn.It's GetDATE() function, Not DetDate
() function.
In SQL Server 2000 Query :
--------------------------
Select GetDate()
Output:
------
2008-01-22 17:37:20.280
Alternate to GetDate() function:
--------------------------------
Select GetUTCDate()
Output:
-------
2008-01-22 17:37:20.280
GetUTCDATE() means Greenwhich Mean Time of Current Date
Time.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the security principal at the database level that represents your session?
what is checksum in sql server.........???
What is the sql case statement used for? Explain with an example?
Explain the usage of floor function in sql server.
can an automatic recovery be initiated by a user? : Sql server administration
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
How to filter out duplications in the returning rows in ms sql server?
Explain indexing and what are the advantages of it?
What are the 7 disadvantages to a manual system?
What is a cache in ssrs?
How to optimize stored procedure optimization?
How to create indexed view?
How would you go about developing a ssrs report?
What are the properties and different types of sub-queries?
What is primary key and example?