Alternative way to DetDate() function?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / mohanakrishnan a.c

5 Answers
10005 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Alternative way to DetDate() function?..

Answer / 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

Alternative way to DetDate() function?..

Answer / vadivu

SELECT CURRENT_TIMESTAMP

(just searched in Help of SQL Server 2005)

Is This Answer Correct ?

4 Yes

1 No

Alternative way to DetDate() function?..

Answer / rajesh.a

Hi Selvaraj,

It is clearly seems to be a spelling mistake.so,stop pointing out such silly mistakes.Any one can knows that he is asking about getdate()

Is This Answer Correct ?

1 Yes

0 No

Alternative way to DetDate() function?..

Answer / 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

Alternative way to DetDate() function?..

Answer / brahma prakash

SELECT current_date(for currentdate only)
SELECT NOW()

Is This Answer Correct ?

0 Yes

3 No

Post New Answer