Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to insert GMT+05:30(Timezone) in ORACLE

864699May 26 2011 — edited Aug 1 2011

Hi,
Actually i want to select customers from the table whose lastacssts should be greater than the time i will be getting from Date object in JAVA.
What i am doing is getting that value from JAVA date which returns the date object in following format

Thu May 26 18:07:57 GMT+05:30 2011

but when i want to execute the above query in ORACLE i am not getting the abbrevation CODE .Given below is the Oracle query i am executing

SELECT distinct cust.custid FROM Customer cust WHERE
cust.custid! = '123' AND (cust.lastacssts AND
TO_TIMESTAMP_TZ('Tue May 24 20:11:20 GMT+05:30 2011', ' DY MON DD HH24:MI:SS TZDTZH:TZM YYYY'))

The Datatype of lastacssts is Date in ORACLE

I Get Following Error

ORA-01857: not a valid time zone
01857. 00000 - "not a valid time zone"
*Cause:
*Action:

So anyone has any idea about how can i represent GMT in oracle Query because when i remove GMT from the query and just place +05:30 it runs fine but from JAVA
I am getting GMT+05:30 and i cant separate GMT from +05:30.I searched on internet but did not find any solution for that.

Any Help Regarding this would be appreciated.

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2011

Added on May 26 2011

#11g, #date, #general-database-discussions, #oracle, #query, #sql, #sql-developer

6 comments

2,218 views