Timezone in Oracle (from UNIX second)

From: Jarl Groneng <jgr_at_imlab.online.no>
Date: Fri, 18 Sep 1998 14:49:47 +0200
Message-ID: <360256EB.677416C4@imlab.online.no>

Hi.

I have a select like this:

select
to_char((to_date('01011970','DDMMYYYY')+(time_start/86400)),'DD Mon YY HH24:MI'),
to_char((to_date('01011970','DDMMYYYY')+(time_fixed/86400)),'DD Mon YY HH24:MI'), problem_summary, entry_id
from admin
where call_category = 1 order by 5 desc

...this select convert from UNIX seconds to "ordinary" date. The database store the date in timezone GMT. I am two hours ahead GMT and wonder if it is possible to include a timezone check in this.

I want this to be dynamic, because in october - mars I am one hour ahead and from mars - october I am two hous ahead GMT.

Anyone have a solution???

Thanks,
:jarl groneng Received on Fri Sep 18 1998 - 07:49:47 CDT