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 |
|
srujan
Starting Member
1 Post |
 Posted - 2005-10-24 : 13:28:12
|
| if a time given in EDT format it must be converted into IST and CET fromats, i was able to convert EDT time to GMT, PMT,EST..but i was unable to convert it to IST and CET, can anyone do for me it is really urgent for me |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-24 : 14:13:19
|
| I am not familiar with IST and CET timezones. I have a UDF that can do timezone conversions for 36 different timezones. It does not appear to support IST or CET though. Could you give us the business rules for this conversion? Do they support daylight savings time and what is their GMT offset? With that information, I should be able to tell you if the code that I have can be used.Tara |
 |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-10-25 : 02:03:30
|
| Hi,have you read Date Time String Transformation in BOL-----------------------------------------------------------MSSQL Server encryption software http://www.activecrypt.com |
|
|
|
|
|
|
Converting into Time Zones