• use select getutctime() , it will give you GST time then use select dateadd() function to get required reuslt

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)