Get Time in Timezone sql

Hi
Is there a way to get the local time for a spesific timezone in sql.
Like in C# I use:
"TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Now, "GMT Standard Time")"
stalebAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
Please refer to this document

http://tsqltoolbox.codeplex.com/
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
getUTCTime() gets the  GMT time
0
 
stalebAuthor Commented:
What about different Timezones? I used GMT standardTime as an example
0
 
stalebAuthor Commented:
Tnx, perfect
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.