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