need a pl/sql function to return if a DATE is in DAYLIGHT SAVINGS TIME.
I need a pl/sql function that takes in a date and returns a boolean as to weather the date is in daylight savings time.
It should take a date as input but if there is none it should default to current date and time(sysdate).
It needs to figure out if the input date (or default today) is in daylight savings time or not. It starts on the 2nd Sunday in March at midnight and it ends on the 1st Sunday in November at midnight. It should return a Boolean value to indicate true if it is in DST and false otherwise.