Re: SQL Date function question

[Bradley Stone <bvstone@xxxxxxxxx>]

I apologize for the typo, that date would actually be stored as

1012011 (Jan 1, 2011)

Brad

On Wed, Jul 6, 2011 at 3:51 PM, Bradley Stone <bvstone@xxxxxxxxx> wrote:
> I've got a program that uses dynamic SQL and I'm having a hard time
> finding documentation for this, or to find out if it's even possible.
>
> The file contains a date in the format MMDDCCYY.  I need to compare
> the year entered in a query with the year in the date.  At first I
> thought I could just substring off characters 5-8, but that won't work
> since for example:
>
> Jan 1, 2011
>
> is stored as
>
> 112011
>
> So obviously that won't work.  :)
>
> Does SQL on the iSeries have a way to convert this type of date to
> something and then yank the year out to compare it against a text
> literal?
>
> Thanks!
>
> Brad