Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-28 : 12:17:31
|
| joshi thomas m writes "Sir , I am trying to replicate a database whic is in Arizona regionand the subscriber is in Michigen region. Subscriber machine's time zone configuration is diffrent from Publisher and distributor machine .Suppose, if time in Arizona is 12:17 AM then time in Michigen region would be 3:18 AM .So I want the value of datetime columns inserted from Arizona regoin to be converted to Michigen time when the data is subscribed.Plz send me a reply soon Thanking u JOSHI THOMAS M" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-29 : 12:47:37
|
| You can use stored procedures to get the data in the subscribing database. Stored procedures is the default. If you are using them, you'll find them in the subscribing database. They are named like this:sp_MS<TypeOfTransaction>_<TableName>You can modify these stored procedures to do what you want. So where you see the datetime column, do a timezone conversion. You can use a UDF that I wrote to do this:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28712Tara |
 |
|
|
|
|
|
replication