RE: SQL Date function question

Hi Brad
GOOD LUCK with this
In other words, the individual pieces (MM and DD) are zero suppressed?
Then how does the following translate
1112011
Is that November 1, 2011
Or
January 11, 2011


Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bradley Stone
Sent: Wednesday, July 06, 2011 4: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
--
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.