A Day Light Saving query

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135590 More actions · Answer 1

just building forward from your query...

What's wrong with :

SELECT
@courseDate AS courseDate,
E.[DST_Start],
E.[DST_End]
FROM [DST_Extent] E
where E.[DST_Start] >= @courseDate
and @courseDate <= E.[DST_End]

this solution has the advantage of being able to use an index more optimal than your function driven version.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

geoff 52196 SSC Enthusiast Points: 104 More actions · Answer 2

Thanks for getting back so promptly. I feel very rude not responding earlier.

Bad news for me though is that your suggestion didn't resolve the issue. I'll get back later with more specific reasons.