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 |
|
divyaram
Posting Yak Master
180 Posts |
 Posted - 2012-03-29 : 07:08:34
|
| HI all,what data type should be given for time which has to display (GMT-07:00) Arizona in sq server 2008Regards,Divya |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-03-29 : 08:31:43
|
| DATETIMEOFFSET, although it won't display the Arizona portion. You'd have to create a lookup table for offsets and timezones. |
 |
|
|
divyaram
Posting Yak Master
180 Posts |
Posted - 2012-03-29 : 09:49:42
|
quote:
Originally posted by robvolk
DATETIMEOFFSET, although it won't display the Arizona portion. You'd have to create a lookup table for offsets and timezones.
I tried that but i am getting error likr this nt build function... i am using sql server 2008Regards,Divya |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-03-29 : 10:18:37
|
| Is your database using a lower compatibility level (8 or 9 instead of 10)? |
|
|
|
|
|
|
DataType doubt