First you Clearly Learn.It's GetDATE() function, Not DetDate () funct

Alternative way to DetDate() function?

Question Posted / selvaraj.v

5 Answers
9569 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

how to use DTS package in 2000,2005,2008 in sql server

1783

Do you know the cursor optimization tips?

928

What is mean by dml?

943

What is self join in sql server joins?

959

Explain powershell included in sql server 2008?

996

What is the Main Difference between ACCESS and SQL SERVER?

1063

What is xml datatype?

1028

Where are SQL server users names and passwords are stored in sql server?

1196

What is the difference between composite index and covering index?

897

Explain isolation levels that sql server supports?

985

What is instead of trigger sql server?

927

Mention the different types of triggers?

1002

What is SQL Azure Data sync?

119

Give an example of SQL injection attack ?

924

What are distributed partitioned views?

1005