Is there a way to tell whether a specific date falls within daylight savings time from a stored procedure inside SQL Server 2000?
The reason I ask is this. I have a third party application that records time stamps in "number of seconds since '31-Dec-1969 17:00'". This is based on our time zone (MST -7). In actual fact, it's "number of seconds since '1-Jan-1970 0:00'".
The problem is that when I conver this to human readable form using dateadd(ss,timestamp,'31-Dec-1969 17:00'), it only works accurately during standard time. As soon as daylight savings time hits, it's off by an hour.
Does anyone have any suggestions how to deal with this?
Thanks in advance!