Recently, I have been given a requirement to convert date time from a standard application server time to users local time with a difference of few hours. Needless to say, I was a looking for a standard function that allows me to perform this calculation in a simplest form ever.
Fortunately Web Intelligence provides a function to allow us to do this, you can look up for RelativeDate() function.
Pixadata 