Re: Best method using SQL to combine date fields (day, month, year)

["Jim Essinger" <dilbernator@xxxxxxxxx>]

Bradley,

I would use Alan's iDate UDF and pass the combined fields
select idate(&month || &day || &year, format) from filename

That will return a usable date.

Jim

On Mon, Oct 20, 2008 at 10:17 AM, Bradley V. Stone <bvstone@xxxxxxxxxxxx> wrote:
> Ok, building some dynamic SQL statements.
>
> Got to a file that has date separated into year, month and day fields.  Ugh.
>
> So, wondering the best/easiest way to combine these so I can use them in an
> SQL statement?  Hopefully some magical SQL command that I can use inline?
>
> Thanks!
>
> Bradley V. Stone
> BVSTools - www.bvstools.com
> eRPG SDK - www.erpgsdk.com
>
> --
> 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.