A snippet

MM = EXTRACT(MONTH FROM ISSUEDATE);
IF (MM < 10) THEN MM = '0' || MM;
DD = EXTRACT(DAY FROM ISSUEDATE);
IF (DD < 10) THEN DD = '0' || DD;
YY = EXTRACT(YEAR FROM ISSUEDATE);

DATA = '<issueDate>' || YY || '-' || MM || '-' || DD || '</issueDate>';

----- Original Message -----
From: "hcarvajalsy" <hcarvajalsy@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, April 26, 2005 3:04 PM
Subject: [firebird-support] concatenate operator is changing the date order


>
>
> 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
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>