This discussion is archived
1 Reply Latest reply: Jan 27, 2013 2:05 PM by Srini Chavali-Oracle RSS

current_timestamp vs daylight saving time

garcol Newbie
Currently Being Moderated
Hello,

I asked some questions in this topic: Re: application time is changed (1 hour later)

But I do not know how to solve this, the problem is, the time in my online application is 1 hour later than is actually is. So 21.30is actually 20.30.

This is my code:
    select 1
    from   vex_rondes rde
    where rde.datum_einde < current_timestamp
    and    rde.id = b_rde_id
rde.datum_einde is a date column filled with dates of course ins this format: 10-01-2013 20:45 (10th January 2013 20h45)

How can I get this current_timestamp correct?

this helps:
select 1
    from   vex_rondes rde
    where rde.datum_einde+(1/24) < current_timestamp
    and    rde.id = b_rde_id
but that's not very elegant nor generic...

Edited by: garcol on 27-jan-2013 12:38

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points