Adjustment for Daylight Saving time
Could anyone please help me on this:
our oracle dbtimezone is currently showing +00:00
our tables have date data type which store date and time as received from an external system sends date/time in UTC
How do I convert the UTC timestamp to BST (British Summer Time) while selecting from the table? I dont want to change the value in the table, just select it as BST.
I have tried different methods like new_time but no luck.
e.g.
select to_date('20120101 23:30:00','YYYYMMDD HH24:MI:SS'), new_time(to_date('20120101 23:30:00','YYYYMMDD HH24:MI:SS'), 'GMT','BST') from dual
returns
01/01/2012 23:30:00 01/01/2012 12:30:00
which I think is incorrect as the BST time should have been 1 hour ahead of GMT. But the above showss it to be 11 hrs behind. I am confused.
Could you please help.