| Author |
Urgent help needed pls
|
|
| Joe D 2005-07-18, 11:23 am |
| Is it possibile to have a database default time different from SQL Server
2000 default time?
A group in my company, wants to move their regional databases to one
centralize sql server in the Central Time Zone but keep the repective
databases in their own time zone.
I have searched but not found any info as of yet.
tia
JD
| |
| David Gugick 2005-07-18, 1:23 pm |
| Joe D wrote:
> Is it possibile to have a database default time different from SQL
> Server 2000 default time?
>
> A group in my company, wants to move their regional databases to one
> centralize sql server in the Central Time Zone but keep the repective
> databases in their own time zone.
>
> I have searched but not found any info as of yet.
>
> tia
>
> JD
You could write a custom GETDATE() funtion that maps a database against
the time zone you really need it in. If you wanted to, you could also
set the server to GMT and store all dates that way without converting
when saved. You could also save GMT datetimes using GETUTCDATE()
regardless of the time zone setting on the server.
You could convert when needed at the client.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
| |
| Neil MacMurchy 2005-07-18, 1:23 pm |
| did you hear "Joe D" <jkdriscoll@qg.com> say in
news:dbgmg3$j0i$1@sx
news1.qg.com:
> Is it possibile to have a database default time different from SQL
> Server 2000 default time?
>
> A group in my company, wants to move their regional databases to one
> centralize sql server in the Central Time Zone but keep the repective
> databases in their own time zone.
>
> I have searched but not found any info as of yet.
>
> tia
>
> JD
>
>
I believe that the time will be based off the OS time. You might be able
to work something out with GETUTCDATE(), but I think you are into heavy
customization (do you bill by the hour? <g> )
--
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs
| |
|
| Thank you for your suggestions and help.
Joe
"David Gugick" <david.gugick-nospam@quest.com> wrote in message
news:uRQp8w7iFHA.2444@tk2msftngp13.phx.gbl...
> Joe D wrote:
>
> You could write a custom GETDATE() funtion that maps a database against
> the time zone you really need it in. If you wanted to, you could also set
> the server to GMT and store all dates that way without converting when
> saved. You could also save GMT datetimes using GETUTCDATE() regardless of
> the time zone setting on the server.
> You could convert when needed at the client.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
| |
|
| Thank you for your help.
I am a salary employee (no hourly billing - :)
"Neil MacMurchy" <neilmcse@nospamf.gmail.com> wrote in message
news:Xns96978747F55C
5neilmcsehotmailcom@
207.46.248.16...
> did you hear "Joe D" <jkdriscoll@qg.com> say in
> news:dbgmg3$j0i$1@sx
news1.qg.com:
>
>
> I believe that the time will be based off the OS time. You might be able
> to work something out with GETUTCDATE(), but I think you are into heavy
> customization (do you bill by the hour? <g> )
>
> --
> Neil MacMurchy
>
> http://spaces.msn.com/members/neilmacmurchy
> http://spaces.msn.com/members/mctblogs
>
>
| |
| Sgt. Sausage 2005-07-18, 8:23 pm |
| After getting burned on this a few times, we've made it a
standard that all dates that go into the database are what
we call "normalized" -- set to a known standard (that for
political reasons is not GMT!).
If it goes into the database, it's "normalized" to this
known standard. If it comes out of the database, it's
converted to local time.
This is handled through a small library on the client
side. All data access goes through this library so there's
really no work for the application programmer. The DBAs,
however, are used to writing queries directly against the
DB and constantly forget to do the conversion.
Personally, I think this should be handled by the database
engine itself, and it would make life quite a bit easier
for all involved.
"Joe D" <jkdriscoll@qg.com> wrote in message
news:dbgmg3$j0i$1@sx
news1.qg.com...
> Is it possibile to have a database default time different from SQL Server
> 2000 default time?
>
> A group in my company, wants to move their regional databases to one
> centralize sql server in the Central Time Zone but keep the repective
> databases in their own time zone.
>
> I have searched but not found any info as of yet.
>
> tia
>
> JD
>
|
|
|
|