Tuesday, February 14, 2012

DATE AND tIME

Can anyone tell if it is possible to change the data and time of your SQL
Server or does the SQL server use the date and time from the PC clock?SQL Server gets the current time from the operating system.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"dfoote" <dfoote@.napcosecurity.com> wrote in message news:u4PTnfYpEHA.556@.TK2MSFTNGP09.phx.gbl...
> Can anyone tell if it is possible to change the data and time of your SQL
> Server or does the SQL server use the date and time from the PC clock?
>|||I will take it one step further and ask is the format taken from the Same
place(OS) or is there a way to change the Date and time Format.?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e$rG3jYpEHA.3172@.TK2MSFTNGP10.phx.gbl...
> SQL Server gets the current time from the operating system.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "dfoote" <dfoote@.napcosecurity.com> wrote in message
> news:u4PTnfYpEHA.556@.TK2MSFTNGP09.phx.gbl...
>> Can anyone tell if it is possible to change the data and time of your SQL
>> Server or does the SQL server use the date and time from the PC clock?
>>
>|||> I will take it one step further and ask is the format taken from the Same
> place(OS) or is there a way to change the Date and time Format.?
What date and time format are you talking about?
--
http://www.aspfaq.com/
(Reverse address to reply.)

No comments:

Post a Comment