Hello
Is there any function in sql server which converts the dates(UTC) to locat time.
problem:
I have let say 20 users and each work in different timezones and each user should be able to see their data in their timezone and the rest will be in their respective timezones.
i don't know what is the best way to do this.
I am storing the dates in uST format and storing the timezone information for each user in the table againest the user and thought this was the best way to do this.
i am stumped with the daylight saving timings as well.
can some one please let me know whether any UDF function to convert this dates.
Thanks
Is there any function in sql server which converts the dates(UTC) to locat time.
problem:
I have let say 20 users and each work in different timezones and each user should be able to see their data in their timezone and the rest will be in their respective timezones.
i don't know what is the best way to do this.
I am storing the dates in uST format and storing the timezone information for each user in the table againest the user and thought this was the best way to do this.
i am stumped with the daylight saving timings as well.
can some one please let me know whether any UDF function to convert this dates.
Thanks