New Topic/Question
Reply
Hi,
I want to get Indian Standard Time (IST) in Sql Server 2005. How can I achieve this?
Note:
SELECT 'SYSDATETIMEOFFSET', SYSDATETIMEOFFSET() this query works fine in Sql server 2008. Is there any option in Sql Server 2005?
Thanks in Advance
1 Replies - 738 Views - Last Post: 11 January 2012 - 09:07 PM
Rate Topic:
Topic Sponsor:
#1
visweswaran28
- New D.I.C Head
Reputation: 0
- Posts: 30
- Joined: 29-October 09
How to Get Indian Standard Time in Sql server 2005
Posted 10 January 2012 - 11:50 PM
Is This A Good Question/Topic?
0
MultiQuoteReplies To: How to Get Indian Standard Time in Sql server 2005
#2
floppyspace
- D.I.C Head
Reputation: 17
- Posts: 150
- Joined: 04-February 10
Re: How to Get Indian Standard Time in Sql server 2005
Posted 11 January 2012 - 09:07 PM
Hi
This is not much help but will head you in the right direction
Look into datetime and smalldatetime.
The SELECT 'SYSDATETIMEOFFSET', SYSDATETIMEOFFSET()was a new feature introduced in 2008 release.
As for setting it to something other than GMT have a look at offsetting the result (+ or -), have a look at:sql 2005 and SQLServerPedia.
Hope it helps.
This is not much help but will head you in the right direction
Look into datetime and smalldatetime.
The SELECT 'SYSDATETIMEOFFSET', SYSDATETIMEOFFSET()was a new feature introduced in 2008 release.
As for setting it to something other than GMT have a look at offsetting the result (+ or -), have a look at:sql 2005 and SQLServerPedia.
Hope it helps.
Was This Post Helpful?
0
Page 1 of 1
|
|
| 