| Keith Kratochvil 2002-08-14, 7:23 am |
| Do you also want the date, or just the time?
select getdate()
select convert(char(8), getdate(),108)
--
Keith, SQL Server MVP
"hsr" <henkr@vippayroll.co.za> wrote in message
news:#$5JSC5QCHA.3216@tkmsftngp12...
> Hi All,
> how do I get the current time of the sql server, instead of the local PC.
> (Just to keep the time syncronized for a call logging system)
>
> The records include the time the call was logged. Should I retrieve the
time
> and then save the time in the table or can i use it with the insert
> statement of the call that is being logged.
>
> Thanks
> Henk
>
>
|