×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
As an Amazon Associate we earn from qualifying purchases.