What I meant it that Helen has shown a way to concatenate every part
of the date one by one, but what I was thinking was automating the format.

Thanks and regards

Bhavbhuti

--- In firebird-support@yahoogroups.com, "Bhavbhuti Nathwani"
<venussoftop@...> wrote:

>
> Hi all
>
> I recently used CAST(tDt AS DATE) (TIMESTAMP field as DATE) in one of
> my SELECT and the date came up as 2007-11-24, is it possible to get
> the date in the computer's regional setting for eg. 24/11/2007?
>
> Thanks
>
> Regards
> Bhavbhuti
>