Converting a server datetime to the mentioned timezone


  • I am facing an issue with the conversion of the timezone to a target timezone. Below is the detail of my question

    I have two inputs

      1) Current timestamp (Server)

      2) Target Timezone (values will be like 'Europe/London' or 'Asia/Chennai' etc..

    So assume the input values are '23-FEB-11 10.33.24' and 'Asia/Chennai'

    I should get the output as '23-FEB-11 16.03.24'

    Please help me by providing a code in SQL Server 2008

    יום רביעי 23 פברואר 2011 10:34

כל התגובות