Re: Timestamp Interval in Hours

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

Well...shut my mouth...this does what I want it to do:

SELECT TMSTNO, char(TMADTE) as AddDate, char(TMAPNO) as AppNum,
tmadtm as AddTime, tmuptm as UpdTime , TIMESTAMPDIFF(8, cast(tmuptm
- tmadtm as char(22))) as Hours FROM tcscmnp WHERE current_date -
30 days <= date(TMADTM)

Thanks!

On Nov 16, 2007 2:22 PM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:
> I see the TMESTAMPDIFF function in V5R4, but I'm on V5R3. Anyone know
> how I can get the difference in hours between two timestamps in SQL?
> I'd rather not write an RPG program, but it may take less time.
>
> Thanks!