File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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
 
Similar Threads
Change Timezone from GMT to EST, the best way to accomplish?
parse date string
Passing java dates timestamp to Javascript's date object
Converting date to different timezones
JSP attendance management project error