Re: Timestamp Interval in Hours

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

Thanks Elvis -

My Q&D worked, but I'll keep your UDF in mind if I even have to do
this 'for real'.

- Michael

On Nov 16, 2007 2:48 PM, Elvis Budimlic
<ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> TIMESTAMPDIFF is supported on V5R3.
> For example:
>
> select timestampdiff(8,
> cast(current_timestamp - (current_timestamp - 1 day) as char(22)))
> from sysibm/sysdummy1
>
> returns 24.
>
> That said, be careful about using this function.  It assumes 30 days month.
> I could not believe IBM went along with this.
>
> We had to work around it in our SQLUDFs project.  See DateDiff UDF
> description at
>  http://www.centerfieldtools.com/_s_q_l_01_u_d_fs.html
>
> I'm guessing writing RPG program is probably your cheapest solution.
>
> Elvis
>
> Celebrating 10-Years of SQL Performance Excellence on IBM i5/OS and OS/400
> http://centerfieldtechnology.com/training.asp
>
>
>
> -----Original Message-----
> Subject: Timestamp Interval in Hours
>
> 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!
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.