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 |
|
divulohi
Starting Member
1 Post |
 Posted - 2009-08-07 : 02:30:42
|
| Hi,Please help me on this. I have an AUDIT_TIMESTAMP field in an SQL DB table which is in GMT Timestamp format as:2009-08-04-12.05.23.495894Please tell me if there is any function which can convert the above format to PST.Thanks in advance,Divya. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-07 : 03:05:03
|
DATEADD(HOUR, -@x, AUDIT_TIMESTAMP)Let @x be the difference in hours between the two timezones.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
How to Convert GMT Timestamp to PST ?