pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
dayname() doubt
4+ messages / 4 participants
[nested] [flat]

* dayname() doubt
@ 2000-03-06 05:11 Annamalai G <gannam@india.dharma.com>
  2000-03-06 07:12 ` Re: [SQL] dayname() doubt Peter Eisentraut <e99re41@DoCS.UU.SE>
  0 siblings, 1 reply; 4+ messages in thread

From: Annamalai G @ 2000-03-06 05:11 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] dayname() doubt
  2000-03-06 05:11 dayname() doubt Annamalai G <gannam@india.dharma.com>
@ 2000-03-06 07:12 ` Peter Eisentraut <e99re41@DoCS.UU.SE>
  2000-03-06 10:20   ` Re: [SQL] dayname() doubt Karel Zak - Zakkr <zakkr@zf.jcu.cz>
  0 siblings, 1 reply; 4+ messages in thread

From: Peter Eisentraut @ 2000-03-06 07:12 UTC (permalink / raw)
  To: Annamalai G <gannam@india.dharma.com>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] dayname() doubt
  2000-03-06 05:11 dayname() doubt Annamalai G <gannam@india.dharma.com>
  2000-03-06 07:12 ` Re: [SQL] dayname() doubt Peter Eisentraut <e99re41@DoCS.UU.SE>
@ 2000-03-06 10:20   ` Karel Zak - Zakkr <zakkr@zf.jcu.cz>
  2000-03-07 23:55     ` Re: [SQL] dayname() doubt Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Karel Zak - Zakkr @ 2000-03-06 10:20 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Annamalai G <gannam@india.dharma.com>; 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
 




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] dayname() doubt
  2000-03-06 05:11 dayname() doubt Annamalai G <gannam@india.dharma.com>
  2000-03-06 07:12 ` Re: [SQL] dayname() doubt Peter Eisentraut <e99re41@DoCS.UU.SE>
  2000-03-06 10:20   ` Re: [SQL] dayname() doubt Karel Zak - Zakkr <zakkr@zf.jcu.cz>
@ 2000-03-07 23:55     ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 2000-03-07 23:55 UTC (permalink / raw)
  To: Karel Zak - Zakkr <zakkr@zf.jcu.cz>; +Cc: Peter Eisentraut <peter_e@gmx.net>; Annamalai G <gannam@india.dharma.com>; pgsql-sql

> 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, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2000-03-07 23:55 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-03-06 05:11 dayname() doubt Annamalai G <gannam@india.dharma.com>
2000-03-06 07:12 ` Peter Eisentraut <e99re41@DoCS.UU.SE>
2000-03-06 10:20   ` Karel Zak - Zakkr <zakkr@zf.jcu.cz>
2000-03-07 23:55     ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox