RE: SQL Date function question

If your example is alpha, You can pick off the year in your example by right(trim(MyDate),4). If numeric, cast MyDate with digits().

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bradley Stone
Sent: Wednesday, July 06, 2011 1:51 PM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: SQL Date function question

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