Subject Re: CAST() as TimeStamp / Date need in regional setting
Author Bhavbhuti Nathwani
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


--- In, "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