Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
3 Search Results Found
1 Forum: SQL & PL/SQL «» Posted on: Tue, 02 April 2013 11:55 «» By: amarnath123
Re: Wierd Behaviour of dates with Time zone
Hi I am using stored proc to insert the above dates into one of the tables. And while doing so I get the ora-01878 error. I thought it might be because of one of the dates and the DST problem. but the above list of dates are not in 2:00 -3:00 am on second ...
2 Forum: SQL & PL/SQL «» Posted on: Mon, 12 March 2012 01:03 «» By: srinivas.k2005
Re: Wierd Behaviour of dates with Time zone
The problem is when the hour part is 02:59:42 , it is throwing error Gives error: ORA-01878: specified field not found in datetime or interval In a prod DB we have a date field stored with that timestamp and its failing with above error while executin...
3 Forum: SQL & PL/SQL «» Posted on: Mon, 12 March 2012 00:57 «» By: srinivas.k2005
Wierd Behaviour of dates with Time zone
Hi, select TO_DATE ( TO_CHAR ( FROM_TZ ( CAST ( TO_DATE ( '2012-03-11 02:59:42', 'YYYY-MM-DD HH24:MI:SS') AS TIMESTAMP), 'CST6CDT') AT TIME ZONE 'Europe/Dublin', 'YYYY-MM-DD'), 'YYYY-MM-DD') dt from dual; Gi...

Current Time: Mon Jun 24 23:07:26 CDT 2019