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 |
|
scvinod
Starting Member
16 Posts |
 Posted - 2009-08-02 : 10:06:30
|
| Hi All, I want to create a column with data type as DateTime.But it must be US pacific time zone.Can any1 help me out please.Thanks in advance.scv |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-08-02 : 11:03:41
|
| A datetime column does include any property which specifies the timezone. You need to control that either at the time you enter your data or alternatively you could adjust the timezone offset at the time you retrieve the data.Be One with the OptimizerTG |
 |
|
|
|
|
|
Column with Date and US specific time