Re: SQL Date function question

Jon,

Thanks for the link. It is not an obvious solution (maybe we are hardwired
to avoid creating extra tables) but, once you see the simplicity of it, it
seems the right way to go.

Thanks again,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Wed, Jul 6, 2011 at 7:27 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

Check out the SQL date reference in today's blog post Brad - personally I'm
never going to bother wrestling with dates in SQL again. We'll be writing
it up fully later but everything you need in that Redbook.


http://ibmsystemsmag.blogs.com/idevelop/2011/07/jon-and-susan-get-educated.html


On Jul 6, 2011, at 5:06 PM, midrange-l-request@xxxxxxxxxxxx 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.

Jon Paris

www.partner400.com
www.SystemiDeveloper.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.