Different times on different instances

Hi,
we have sql server 2000, sp4 and we need to add new instance to this server.
Is it possible to setup time (zone) different than server local time for this
new instance?
I am asking this because application which should rely on new instance uses
extensively getdate() function, and cost of redevelopement would be huge...
How about changing getdate()?
Thanks,
Pedja
Pedja wrote:
> Hi,
> we have sql server 2000, sp4 and we need to add new instance to this
> server. Is it possible to setup time (zone) different than server
> local time for this new instance?
> I am asking this because application which should rely on new
> instance uses extensively getdate() function, and cost of
> redevelopement would be huge... How about changing getdate()?
> Thanks,
> Pedja
Not unless you are using virtual servers, then maybe. If you change
getdate() to GETUTCDATE(), you could store all your dates in GMT.
David Gugick - SQL Server MVP
Quest Software