Re: Converting a numeric date value to a DATE in SQL

[Jeff Young <jyoung0950@xxxxxxxxx>]

Thanks to all.
I will use the solution suggested by Birgitta and Robert.

Rob,
The DATE question is for a specific issue that I am looking at, and it is
not worth the hassle with the customer to persuade them that the iDate
software is totally safe.  Their vetting process can take weeks and I do
not have that time.

Jeff Young
Sr. Programmer Analyst

On Tue, Sep 9, 2014 at 12:44 PM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

> Assumed your date is 8P 0 or 8S 0 and in the format YYYYMMDD, then is the
> easiest ways:
>
> Date(Digits(YourNumdate) concat '000000')
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
> Jeff
> Young
> Gesendet: Tuesday, 09.9 2014 16:39
> An: Midrange Systems Technical Discussion
> Betreff: Converting a numeric date value to a DATE in SQL
>
> All,
> V6R1 system.
> Using SQL, how do I convert a numeric value of a database field in ISO date
> format (ccyymmdd)  to a DATE data type for comparison?
> I need to select all records with a date that is equal to a value input by
> the user.
>
> TIA,
>
> Jeff Young
> Sr. Programmer Analyst
> --
> 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.
>
>
> --
> 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.