Hello,
I want to concatenate a message with a date field. If a do a select of
the data field, it is shown as mm/dd/yyyy, but when I do the
concatenate it changes to yyyy/mm/dd. How can I keep the mm/dd/yyyy?
thanks

select for_a || ' ' || t1.tempdate, t1.tempdate from MLETT T1 ,
MLANG T2 WHERE
T1.LANG = 'E'
and t1.cd = t2.cd

approved until 2005-05-17 05/17/2005

I need to get approved until 05-17-2005