Re: [GENERAL] dealing with invalid date

2004-10-16 Thread Scott Marlowe
On Sat, 2004-10-16 at 21:03, Mage wrote: > Hi, > > can pgsql acceppt invalid date values? Sometimes it would be nice to > convert 2003-02-29 to 2003-03-01 or to 2003-02-28 automatically instead > of throwing back an error message. If you're using a language with a date / time lib that

Re: [GENERAL] dealing with invalid date

2004-10-16 Thread Mike Nolan
> can pgsql acceppt invalid date values? Sometimes it would be nice to > convert 2003-02-29 to 2003-03-01 or to 2003-02-28 automatically instead > of throwing back an error message. I guess the question is 'accept from where?' This isn't a database question as much as it is a data INPUT questio

Re: [GENERAL] dealing with invalid date

2004-10-16 Thread Doug McNaught
Mage <[EMAIL PROTECTED]> writes: > Hi, > > can pgsql acceppt invalid date values? Sometimes it would be nice to > convert 2003-02-29 to 2003-03-01 or to 2003-02-28 automatically > instead of throwing back an error message. If you want MySQL, you know where to find it. -Doug -- Let us

[GENERAL] dealing with invalid date

2004-10-16 Thread Mage
Hi, can pgsql acceppt invalid date values? Sometimes it would be nice to convert 2003-02-29 to 2003-03-01 or to 2003-02-28 automatically instead of throwing back an error message. Mage ---(end of broadcast)--- TIP 6: Have you searche