The moose likes Oracle/OAS and the fly likes How to insert GMT+05:30 in ORACLE Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to insert GMT+05:30 in ORACLE" Watch "How to insert GMT+05:30 in ORACLE" New topic

How to insert GMT+05:30 in ORACLE

Pawan Choure

Joined: May 11, 2008
Posts: 27

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 abbreviation CODE .Given below is the Oracle query i am executing

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"

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

Pawan Choure
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
Hi Pawan,

Why do you use timestamp? Can you post the fraction of java code? Let us see how you pass date parameter to query statement.
It is sorta covered in the JavaRanch Style Guide.
subject: How to insert GMT+05:30 in ORACLE
It's not a secret anymore!