Pulling DST for a future date from Oracle?
Posted on 2011-03-07
I am pulling data from a table that contains scheduling information and I am curious if there is a way for Oracle to calculate DST based on future dates. Say I am pulling data from the table for 3/17/2011 17:00:00 GMT, that time local for me should be either 16:00:00 or 4PM instead of 5PM.
Now, I know that oracle can give me the correct time for my timezone based off of what the current date is, but is it possible to do this for a future date?
I tried using the New_Time() function, that it uses (-5) because for the current sysdate DST is not in effect, but on 3/17/2011 it should be using -4...