UTC DateTime to Local DateTime

r_ganesh76 · April 4th, 2005, 04:19 AM

Hi Experts,

Is there any way of getting the LocalDateTime from a DateTime saved as UTC. The date is stored in the database as UTC. But I want to get the date as Local Time with the Daylight savings adjusted.

Someone please help me solve this issue.

Thanking you in advance

Regards
Ganesh

shahchi1 · April 4th, 2005, 08:21 AM

Here is the UDF that you might be interested in looking into

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28712