Subject | Re: CAST() as TimeStamp / Date need in regional setting |
---|---|
Author | Bhavbhuti Nathwani |
Post date | 2007-11-30T12:10:40Z |
Hi Adam
--- In firebird-support@yahoogroups.com, "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
Bhavbhuti.