Re: SQL Date Problem

Thanks, this solved my problem. I am having another problem with SQL
dates and stuff, but I will post a new thread on that when I have more
details.


On Wed, 16 Mar 2005 14:47:47 -0800, Tony Carolla <carolla@xxxxxxxxx> wrote:
> <snip>
> > inv_date = %char(%date(dapiinstin:*USA));
> ...
> > inv_date = %char(%date(%char(dapiinstin):*USA));
> <snip>
> 
> Almost.  The %Char BIF accepts a date format, so you should be able to use:
> 
> inv_date = %char(dapiinstin:*USA);
> 
> --
> "Enter any 11-digit prime number to continue..."
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
> 


-- 
Mike Wills
Midrange Programmer/Lawson Administrator
koldark@xxxxxxxxx
http://www.mikewills.name
Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.