>>>>Very stupid question, but can you simply use SELECT GETDATE() ?
>>>
>>>Celko prefers CURRENT_TIMESTAMP as he says Getdate() is propriatery...
>>>
>>>But I use GETDATE() myself mostly...
>>
>>Proprietary to sqlserver you mean?
>
>Yes.

I thought you had to adjust for timezone though if you used that...

I have this that I got from help at some point in time that I used for testing:

SELECT SYSDATETIME()
,SYSDATETIMEOFFSET()
,SYSUTCDATETIME()
,CURRENT_TIMESTAMP
,GETDATE()
,GETUTCDATE();

and:

SELECT CONVERT (time, SYSDATETIME())
,CONVERT (time, SYSDATETIMEOFFSET())
,CONVERT (time, SYSUTCDATETIME())
,CONVERT (time, CURRENT_TIMESTAMP)
,CONVERT (time, GETDATE())
,CONVERT (time, GETUTCDATE());

to see the difference...