DB2 Dates and Ibatis

[abehl]

Hi I had a question about DB2 dates.

I am trying to understand how the flow works in a system.

Firstly date is stored in the database as a 21 character format an example is
"2008080814532500+0000" it seems to be of the form "yyyyddMMhhmm....".

The dates are stored with

INSERT INTO TABLE1(
DATE_TO)
VALUES(
#dateTo:CHAR#)
 

And its accessed using

<isNotNull property="StartDateTo" prepend="AND">
      DATE_TO &lt;= #StartDateTo#
    </isNotNull>
 

Now the date is passed as a date object in the form of milli sec since epoch.

I am not able to understand how the comparison is taking place and all.

Can anyone explain this to me please.

Thank you very much.

[Nepomuk]

Hi abehl!

Correct me if I'm wrong, but I can't see what this has to do with Java. If you've just posted it in the wrong place, just tell us where it should go and we'll move it there. If it IS something to do with Java, please go into more detail.

Greetings,
Nepomuk

[abehl]

The date object I talked about is a java date object.

I dont know where else the question would suit coz its not purely a database related question as well.