How to convert Server time into Localtime in sql server 2005

Question

Hi Am displaying date and time its showing US Date and time(10.30 hours behind) but i need indian date time. how to change please help to me? Thank You

Akkiraju Ivaturi · Answer

You should use the DATETIMEOFFSET datatype which includes the timezone and the SWITCHOFFSET method to switch between timezones. Also: to get the current time use SYSDATETIMEOFFSET() instead of GETDATE() -- 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')

Jignesh Trivedi · Answer

hi Prabhaker are you displaying datetime from database on your screen? Please refer below link it might be help you. http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx http://wiki.answers.com/Q/Using_HTML_how_to_display_date_and_time hope this will help you.