Re: New version of Idate

["Jim Essinger" <dilbernator@xxxxxxxxx>]

Hey Alan,

If no one else says it - Thanks!  I use your utility all the time on our
CYYMMDD fields.

JIm

On 5/24/07, Alan Campin <Alan.Campin@xxxxxxxxxxxxxxxx> wrote:
> I have posted a new version of iDate, my SQL user defined function to
> convert dates to date data types from iSeries type dates.
>
>
>
> I, also, added a new function called ConvertToIDate. This is probably
> not something people will use a lot but I had a need and added it.
>
>
>
> ConvertToIDate takes a Date Data Type and converts it to a iSeries type
> of date. Specifically, the value is returned as integer field in the
> format requested.
>
>
>
> Assume your default date format of *CCYMD.
>
>
>
> Select ConvertToIDate(Date_Field) From YourFile
>
>
>
> You get back 20070524.
>
>
>
> Or
>
>
>
> Select ConvertToIDate(Date_Field,'*MDY') From YourFile
>
>
>
> You get back 052407.
>
>
>
> Also, a bug fix with a character date that was blank.
>
>
>
> You can download at www.think400.dk/downloads.htm
>
>
>
>
>
> --
> 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.