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
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: compare Timestamp value from DB2
 
Similar Threads
Converting String to util.Date and then sql.Date
Date, time and timestamp
getParameters names from jsp?
DB2 query cannot work using preparedstatement
Compiler Says That My Class Is Not "public"!