Decreasing hours from a date field

[MikeM19]

Hello guys,

I'm running a report where i'm extracting from my db a java.sql.timestamp field, is there any way to decrease the hour part? i mean if i have a "04/09/15 07:24 PM" how can i convert it to "04/09/15 02:24 PM", i hope someone around can help me with this.

 

Regards!

[asimkin]

Hi,

you can use a Java expression like below to decrease 2 hours form a date field 

new Date($F{orderdate}.getTime() + 2 * 3600*1000)

3600*1000 is 1 hour in milliseconds

[hozawa]

Since the data type is a Timestamp (note the capital "T"), use the following to get time one hour before.

Timestamp oneHourAgo = new Timestamp(System.currentTimeMillis() - (3600 * 1000));

BTW, asimkin's reply is adding 2 hours so you'll get a time 2 hours later.

[MikeM19]

Thank you both for your answers,

Asimkin,

I tried with your expression but there is no change, i use it on the Text field expression, is that ok? any additional thing i must do?

Hozawa,

I'm pretty new with Ireports, i really don't know where to implement your suggestion, can you give more details about it?

Best regards!

[hozawa]

Sorry for the messed up formatting. Corrected it.

[MikeM19]

Thanks you both,

What i did to make this work was to use the expression "new Date($F{my_field}.getTime() - 5 * 3600*1000)" on the text field expression propertie and it totally works, thanks to asimkin and hozawa for putting me on the right way on this one.

Best regards!