Re: SQL Date Conversion Statement Error

[Dennis <iseries@xxxxxxxxxxxx>]

Your job log will have finer detail about that error.  Take a look there, and if the issue is still not clear, please share with us the messages from the log.
++
Dennis
++
 "When I was a boy of fourteen, my father was so ignorant I could hardly stand to have the old man around.  But when I got to twenty-one, I was astonished at how much he had learned in seven years."
     -- Mark Twain 


 

Sent from my Galaxy tablet phone.  Please excuse my brevity.
For any grammatic/spelling errors, there is no excuse.
++


"Mike Wills" <mike@xxxxxxxxxxxx> wrote:

> I have a field that is a decimal date (YYYYMMDD). I need to find all
> records that are a year or less old. Since date are so easy, I am
> trying to do:
>
> WHERE DATE(SUBSTR(CHAR(A.CPADDT),1,4) CONCAT '-' CONCAT
> SUBSTR(CHAR(A.CPADDT),5,2) CONCAT '-' CONCAT
> SUBSTR(CHAR(A.CPADDT),7,2)) > CURRENT_DATE - 1 YEAR
>
> This works great in the SELECT portion. When I put it in the WHERE
> section I get "Selection error involving field *N."
>
> I am really started to hate decimal dates just as much as our other
> developer hates date fields.
>
> Any ideas of what I am doing wrong?
>
> --
> Mike Wills
> http://mikewills.me
> -- 
> 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.