It's possible to compare them using DIGITS to convert the numeric date
to a character format.  The dates must be in the same format though and
in YYMMDD format.  If they are in MMDDYY format or the 8 byte date has 4
digit years you can't compare them.  You can build a work date field
using concatenate but that can get kind of complex.  Check the archives
for this list and the RPG list.  Date comparison and conversion in SQL
comes up pretty frequently.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rowe, Sheri
Sent: Tuesday, November 28, 2006 1:57 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Another SQL question.

I need to update fields in FILEA based on a date comparison
with FILEB.
However, the date in FILEA is defined as 8A and the date in
FILEB is defined as 6S.  Is it possible to compare these
fields even though they are not the same format?

It's a one-time fix and I was hoping avoid writing a program.


Sheri Rowe
Timex Canada

Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.

This thread ...

Return to Archive home page | Return to MIDRANGE.COM home page