Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2010-05-15 Thread Pavel Stehule
Hello 2010/5/16 Ben Hockey : > i apologize for bringing this up from over 2 years ago but i haven't been > able to find how this issue was resolved. it isn't bug, but request for new feature. look on http://wiki.postgresql.org/wiki/Developer_FAQ I have nothing against some new datestyles - xml,

Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2010-05-15 Thread Ben Hockey
i apologize for bringing this up from over 2 years ago but i haven't been able to find how this issue was resolved. the following is from the ecmascript 5 specification at http://www.ecmascript.org/docs/tc39-2009-043.pdf page 168: 15.9.1.15 Date Time String Format ECMAScript defines a stri

Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2007-08-23 Thread Russell Smith
Alvaro Herrera wrote: Russell Smith wrote: The issue is output, not input. SET datestyle='dmy'; SELECT '03-03-2004'::date Will return '2007-03-03', not 03-03-2004 as is the set datestyle. You are aware that DateStyle controls both input and output, _separately_, yes? No, I've RTFM'd to

Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2007-08-22 Thread Peter Eisentraut
Randolf Richardson wrote: > After convincing clients and colleagues to switch from Oracle (and > others) to PostgreSQL, an issue that comes up is the need to > customize DATESTYLE. Because this isn't possible, Sure it's possible. You replace the respective data type output functions with somethi

Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2007-08-22 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Yea, it isn't too hard to do, especially for output; input might be > harder. This is the first request we have ever gotten for this so it is > doubtful we would add this feature unless there is more demand. I don't think any input-side changes are bei

Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2007-08-22 Thread Michael Glaesemann
On Aug 22, 2007, at 10:13 , Randolf Richardson wrote: The datestyle I need is "-Mon-DD" so that reports can easily be generated that show dates like 2007-Aug-22. For people reading the output, there will be absolutely no confusion about what the date is. Are you generating report

Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2007-08-22 Thread Randolf Richardson
> Randolf Richardson wrote: > > > After convincing clients and colleagues to switch from Oracle (and others) > > to PostgreSQL, an issue that comes up is the need to customize DATESTYLE. > > Because this isn't possible, the developers who were against the move to > > PostgreSQL make it political

Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2007-08-22 Thread Bruce Momjian
Randolf Richardson wrote: > After convincing clients and colleagues to switch from Oracle (and others) > to PostgreSQL, an issue that comes up is the need to customize DATESTYLE. > Because this isn't possible, the developers who were against the move to > PostgreSQL make it political and recommend

Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2007-08-22 Thread Heikki Linnakangas
Randolf Richardson wrote: >>> I'm hoping that this suggestion will be an easy one to implement. >> Probably wouldn't be too hard. > > That's great! I'm guessing that this is due to the work already > done with the to_char() function. Just to be clear, I don't have any plans to actually do

Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2007-08-22 Thread Alvaro Herrera
Russell Smith wrote: > The issue is output, not input. > > SET datestyle='dmy'; > SELECT '03-03-2004'::date > > Will return '2007-03-03', not 03-03-2004 as is the set datestyle. You are aware that DateStyle controls both input and output, _separately_, yes? -- Alvaro Herrera

Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2007-08-22 Thread Russell Smith
Heikki Linnakangas wrote: Randolf Richardson wrote: After convincing clients and colleagues to switch from Oracle (and others) to PostgreSQL, an issue that comes up is the need to customize DATESTYLE. Because this isn't possible, the developers who were against the move to PostgreSQL make

Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2007-08-22 Thread Heikki Linnakangas
Randolf Richardson wrote: > After convincing clients and colleagues to switch from Oracle (and others) > to PostgreSQL, an issue that comes up is the need to customize DATESTYLE. > Because this isn't possible, the developers who were against the move to > PostgreSQL make it political and recommen

[BUGS] BUG #3563: DATESTYLE feature suggestion

2007-08-22 Thread Randolf Richardson
The following bug has been logged online: Bug reference: 3563 Logged by: Randolf Richardson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: NetBSD 4 (beta), NetBSD 3.1, NetWare 6.5 Description:DATESTYLE feature suggestion Details: After