Gettting time of SQL Server Computer

[Dan]

Hi everyone,

Is there a system stored procedure or another way that I can retrieve
the current date and time of the SQL Server computer?


Any info would be appreciated...

Thanks in advance,

Dan

[Dan Guzman]

Re: Gettting time of SQL Server Computer

You can use GETDATE() or CURRENT_TIMESTA MP:

SELECT GETDATE()
SELECT CURRENT_TIMESTA MP


--
Hope this helps.

Dan Guzman
SQL Server MVP


"Dan" <trudell_dan@ho tmail.com> wrote in message
news:403f2fa1.0 311250543.3426a 437@posting.goo gle.com...[color=blue]
> Hi everyone,
>
> Is there a system stored procedure or another way that I can retrieve
> the current date and time of the SQL Server computer?
>
>
> Any info would be appreciated...
>
> Thanks in advance,
>
> Dan[/color]