Thanks a lot Dimitry for a quick response.

I tried your suggestion, more like
' dtd. ' || CAST(CAST(tPS.tDt AS DATE) AS VARCHAR(20))
for obvious reason, that is fine and it works as promised.

Now my issue is that the date come up as 2009-06-09, that is a bit of a problem from a users perspective as they would like to have it in the local 09/06/2009 (or 09-06-2009) format

Is this possible?

Thanks and regards.
Bhavbhuti

--- In firebird-support@yahoogroups.com, Dimitry Sibiryakov <sd@...> wrote:
>
> > Is there a better way to do this?
>
> Definitely, cast(dtd as varchar(20)) is much better.
>
> SY, SD.
>