| From: | Karel Zak - Zakkr <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | Annamalai G <gannam(at)india(dot)dharma(dot)com>, pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] dayname() doubt |
| Date: | 2000-03-06 10:20:00 |
| Message-ID: | Pine.LNX.3.96.1000306110958.3042D-100000@ara.zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Mon, 6 Mar 2000, Peter Eisentraut wrote:
> On Mon, 6 Mar 2000, Annamalai G wrote:
>
> > Does the SQL92 standard tell anything about the case of the return
> > value of the function dayname(). I mean should it return Upper or
> > Lower case values? Or is it left to the implementor to decide?
>
> There is no such function in SQL. Any human language output would be
> locale dependent anyway.
>
in 7.0:
to_char(now(), 'DAY') for MONDAY
to_char(now(), 'Day') for Monday
to_char(now(), 'day') for monday
... but all is in English, and as said Peter it isn't SQL92 like
(but Oracle compatible)
(Any support for a locale output is plan for far far far future....)
Karel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | zoltan.sebestyen | 2000-03-06 11:23:29 | index file's growing big |
| Previous Message | zoltan.sebestyen | 2000-03-06 10:11:33 |