how to convert est time to ist time

Posted by Suneel161 under Regular Expressions on 5/24/2010 | Views : 6298 | Status : [Member] | Replies : 2
hii

my server located on us.but i want indian time.how to convert est to ist.plz help me..




Responses

Posted by: Vuyiswamb on: 5/25/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
I had a friend who had this problem , and till now we did not get a solution. SQL takes the timezone that has been setup in the Control panel and that is kept in the bios. The only Solution is to find a local hoster and host with them.

Thank you for posting at Dotnetfunda

Vuyiswa Maseko


Thank you for posting at Dotnetfunda
[Administrator]

Suneel161, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: RAAVIKUMAR on: 11/6/2012 [Member] Starter | Points: 25

Up
0
Down

-- gets current date/time in the current timezone
SELECT
SYSDATETIMEOFFSET()

-- get the current date/time in your preferred timezone +05:30 UTC being Indian Std. Time
SELECT
SWITCHOFFSET(SYSDATETIMEOFFSET(), '+05:30')


SELECT CAST(SWITCHOFFSET(SYSDATETIMEOFFSET(), '+05:30') AS DATETIME)

Suneel161, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response