Postgres Pro
Downloads
Home   >   mailing lists

Thread: dayname() doubt

dayname() doubt

From
Annamalai G
Date:
Hello All!!

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?

Thank U for Ur info.

Regards,
anna
----

kibo Albanian counter-intelligence DES smuggle Marxist Treasury
terrorist supercomputer FBI NORAD Ft. Bragg PLO arrangements KGB

Re: [SQL] dayname() doubt

From
Peter Eisentraut
Date:
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.

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

Re: [SQL] dayname() doubt

From
Karel Zak - Zakkr
Date:
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

Re: [SQL] dayname() doubt

From
Bruce Momjian
Date:
> 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....) 

The upper/lower case thing is totally cool.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026