How to convert Server time into Localtime in sql server 2005

Aug 21 2012 6:14 AM

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

Answers (2)

I need from and To dates query in sql server 2005,

delete reapeated row with one column value