Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes compare Timestamp value from DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "compare Timestamp value from DB2" Watch "compare Timestamp value from DB2" New topic
Author

compare Timestamp value from DB2

vivien siu
Ranch Hand

Joined: Nov 10, 2005
Posts: 143
Hello, this is the logic I need to code:

1. A method get yesterday's date which will return me a Java.Util.Date object.
2. get a timestamp value from DB2 table.
3. get the date value only from the timestamp.
4. Then, use the Java.Util.Date object to compare the Timestamp's date value I get from DB2 table.

my question is I don't know how to compare a Date object with a Timestamp value from DB2. What is DB2's built-in method to get date only from timestamp?

my code:



this is the error I getting:
com.ibm.db2.jcc.b.SQLException: An unexpected token "11" was found following "TMTDATE = 2006-03-15". Expected tokens may include: "OR".


I'm not available, my BF's name is WORK.
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Dont go for any DB specific methods. I suggest you to do this with your code. You can use java.text.SimpleDateFormat class to format the date and get only the date part into a util.Date object from Timestamp object. Now you can are having 2 util.Date objects. No more problems.

You can also work with Calendar.

[Edited to make it more clear]
[ March 16, 2006: Message edited by: Adeel Ansari ]
vivien siu
Ranch Hand

Joined: Nov 10, 2005
Posts: 143
this is what I used instead:


will try to use the Date(db2 timestamp) method also because the time part is useless to me

thank you!
Reid M. Pinchback
Ranch Hand

Joined: Jan 25, 2002
Posts: 775
I think you are making your life harder than need be. Don't even try to serialize the date as a string. Just use a prepared statement and bind the date as a parameter. Date serialization into literals is often touchy to get a database to accept, and a real nightmare if you have to support more than one database vendor.


Reid - SCJP2 (April 2002)
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Originally posted by Reid M. Pinchback:
I think you are making your life harder than need be. Don't even try to serialize the date as a string. Just use a prepared statement and bind the date as a parameter. Date serialization into literals is often touchy to get a database to accept, and a real nightmare if you have to support more than one database vendor.


Cent percent agreement. See this.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: compare Timestamp value from DB2