Bhavbhuti Nathwani wrote:

> I am using the following (partial) code to get a string of a date from a datetime field:
> ' dtd. ' || CAST (EXTRACT(DAY from tPS.tDt) AS CHAR(2)) || '/' || CAST (EXTRACT(MONTH from tPS.tDt) AS CHAR(2)) || '/' || CAST (EXTRACT(YEAR from tPS.tDt) AS CHAR(4))
>
> Is there a better way to do this?

It would be best retrieve dates as dates and create a string
representation on the client side, in your application. But, if you
really need to, there are various options listed here:

http://www.firebirdfaq.org/faq314


HTH

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com