Is there any function which gives me time along with time zone? RRS feed

  • Question

  • hi currently i am using getdate() to get the date from sql server but it returns the date without time zone something like following

    22-03-1977 22:33:33 

    In the above there is no timezone information. 

    is there any function to get the time along with the timezone? something like below

    22-03-1977 22:33:33 IST

    Thanks in advance

    Saturday, March 27, 2010 7:21 AM