|
Home > Archive > MS SQL Server > December 2006 > SQL Server 2000 server time question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server 2000 server time question
|
|
| Jason Huang 2006-12-07, 12:12 am |
| Hi,
In my SQL Server 2000, how do I know the SQL server's current time ?
Thanks for help.
Jason
| |
| Geoff N. Hiten 2006-12-07, 12:12 am |
| Select getdate()
or
Select current_timestamp
You get the date as a bonus.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jason Huang" < JasonHuang8888@hotma
il.com> wrote in message
news:OTUiBNaGHHA.1188@TK2MSFTNGP06.phx.gbl...
> Hi,
>
> In my SQL Server 2000, how do I know the SQL server's current time ?
> Thanks for help.
>
>
> Jason
>
| |
| Hari Prasad 2006-12-07, 12:12 am |
| Hello,
Use one of the below commands:-
select convert(varchar,getd
ate(),108)
or
select convert(varchar,curr
ent_timestamp,108)
Thanks
Hari
"Jason Huang" < JasonHuang8888@hotma
il.com> wrote in message
news:OTUiBNaGHHA.1188@TK2MSFTNGP06.phx.gbl...
> Hi,
>
> In my SQL Server 2000, how do I know the SQL server's current time ?
> Thanks for help.
>
>
> Jason
>
|
|
|
|
|