1 Replies - 2436 Views - Last Post: 11 January 2012 - 09:07 PM Rate Topic: -----

#1 visweswaran28  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 45
  • Joined: 29-October 09

How to Get Indian Standard Time in Sql server 2005

Posted 10 January 2012 - 11:50 PM

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
Is This A Good Question/Topic? 0
  • +

Replies To: How to Get Indian Standard Time in Sql server 2005

#2 floppyspace  Icon User is offline

  • D.I.C Regular

Reputation: 48
  • View blog
  • Posts: 254
  • 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.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1