Re: SQL cursor inputting default dates from a DDS file

[Alan Cassidy <cfuture@xxxxxxxxxxx>]

That's a good question, and I'll add an SQL statement to make sure, but 
I think the answer to your question is Yes.


On 1/26/2021 4:35 PM, Therrien, Paul via RPG400-L wrote:
> not sure if this is the answer, but in your connection configuration do you have *ISO as date format?
>
> -----Original Message-----
> From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Alan Cassidy
> Sent: Tuesday, January 26, 2021 4:13 PM
> To: rpg400-l@xxxxxxxxxxxxxxxxxx
> Subject: SQL cursor inputting default dates from a DDS file
>
> Good afternoon Ladies and Gentlemen,
>
> I'm trying to do a quick RPG query with an SQL cursor, but I need to be able to input three dates, any one of which has '0001-01-01' in the filtered subset I will try to fetch. Ran my statement in the separate SQL scripting window (from RDi) but it threw the error that there is a conversion error. I"m sure the above zero-one date is the culprit.
>
> I'm sure I solved this once, years back, but if anybody has the quick answer to as to how I can cast those dates, I'd sure appreciate it and would send good vibes your way!
>
> (I wouldn't even mind if our global SQL guru piped in her thoughts! You know who you are!)
>
> --aec
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com