Hi all

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?

Thanks and regards
Bhavbhuti