hi ,
i have a query that manipulate date column in oracle
that needs to be converted to db2.

the oracle query:
select TRUNC(emeh_date_time - -7/24) + -7/24
from <table>

whats the db2 version??

10x

What does it do in Oracle?

the trunc function in oracle truncate the time from the datetime .
and in the statement context: its truncating the emeh_date_time and adds hours then remove hours

A little confused as to why you'd want to add then remove hours? But anyway you're probably looking for the TIME function combined with the adding of a duration, ie:

TIME(CURRENT TIMESTAMP) + 3 hours

jono

Ahh, I think you mean that the time is truncated, not return, I think I misread.

DATE(blah) will do the trick on that one then. You can still use the duration.

yes i need to had time to a date function
like select date(<col type timestamp>) + 3 hours (3 is a parameter)

can u specify the full select cause i tried it and it didnt work
10x

I'm still not 100% clear on what you're trying to do.

DATE(timestamp) will return the date portion.

You can't add hours to a DATE though, only days, months, etc. But you can add hours to the timestamp before you apply it.

So
DATE(CURRENT TIMESTAMP + 3 HOURS)
or
DATE(CURRENT TIMESTAMP) + 1 DAY

should both work... replacing CURRENT TIMESTAMP with what I presume is your TIMESTAMP column.

10x thats what i was looking 4 :-)