On 26 Apr 2005 at 21:04, hcarvajalsy wrote:

>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?

Do concatenation in your application. FB uses fixed format for
converting date to string (YYYY-MM-DD or DD-MMM-YYYY depending on
dialect).
--
SY, Dimitry Sibiryakov.