Subject Re: CAST() as TimeStamp / Date need in regional setting
Author Bhavbhuti Nathwani
Hi Adam

--- In, "Adam" <s3057043@...> wrote:
> It has always puzzled me why folk try to ask how to get the server to
> perform any data-type to string formatting. The same goes to using
> CURRENT_TIMESTAMP etc. Perhaps I am the only one with users living in
> different timezones who all want different display conventions ;)

You are lucky you have users who are computer literate in the true
sense. :)

> 2. Use Cast(Extract(Day from ...) as varchar(2) || '/' ...... etc

OK, I will go with this one.

Thanks and Regards