Re: SQL Date Math

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

Charles' CvtNumtoDateISO function works swell! It takes 120 seconds
for my query (56M records) using the date and substr method, and 39
seconds for the CvtNumToDateISO method. And that's on the development
system. Much faster on the production system.

On Nov 13, 2007 3:24 PM, Elvis Budimlic
<ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> 1) sorry, I missed that (too many posts to read them all in detail)
> 2) by casting I meant formatting it so it fits the field's data type; your
> UDF is a perfect example
> 3) agreed
>
> It looks like OP will go with casting/formatting the numeric so it fits the
> DATE instead anyway.
>
> Elvis
>
> Celebrating 10-Years of SQL Performance Excellence on IBM i5/OS and OS/400
> http://centerfieldtechnology.com/training.asp
>
>
> -----Original Message-----
> Subject: RE: SQL Date Math
>
> Three things Elvis...
>
> 1) I already mentioned the performance issue ;-)
> 2) You can't CAST() from Date to Numeric
> 3) The UDF shown was for the date to numeric conversion, to resolve issues 1
> & 2
>
> (Just didn't want to give somebody reading the archives the wrong idea about
> my UDF <grin>)
>
> Charles
>
>
> --
>
> 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.