I've a simple query that I've not been able to solve. I'm comparing day of year to day of year to find out someones birthday and it it returning me two days.
Note: the @birthday field is a "Date"
Result (today 05/14):
(Extract(DOY FROM E0.tsBirthdate) = Extract(DOY FROM (GetDate()) AT TIME ZONE 'Europe/Lisbon'))
As far as I understand the problem seems to be in the Time Zone but I can't see how to solve it...
Does any one have a suggestion on how to solve this issue?
Thank you for the suggestion.
It is a Date not a Datetime, non the less I've already tried that