This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Soft Skills and have John Sonmez on-line!
See this thread for details.
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


Win a copy of Soft Skills this week in the Jobs Discussion forum!
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
Author

How to insert GMT+05:30 in ORACLE

Pawan Choure
Greenhorn

Joined: May 11, 2008
Posts: 27

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 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"
*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


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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to insert GMT+05:30 in ORACLE