Try this

CAST(DATE1 as CHAR(20) ) || ' - ' || CAST(DATE2 as CHAR(20) )

ibrahim Bulut wrote:

>Hi,
>i am using interbase 6.2
>i have a problem about timestamp field.
>
>i have two timestamp field and i must concat them.
>DATE1=01.01.2001
>DATE2=01.06.2002
>
>i must concat them into a string like that 01.01.2001 - 01.06.2002
>i am using that
>
>TIMEFIELD VARCHAR(30);
>TIMEFIELD=DATE1 ||' '||DATE2;
>
>When i execute this stored procedure,
>i get this result
>1-JAN-2001 - 1-JUN-2002
>
>i don't want that result.
>i want this result: 01.01.2001 - 01.06.2002
>
>how can i do it.
>
>
>
>ibrahim Bulut
>Software Developer
>Republic of Turkey
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>