Re: [RDBO] problem with MySQL date and datetime columns

2005-10-02 Thread Terrence Brannon
I think that -00-00 in your data model is trying to mean what NULL can mean. Can you tell us the semantics of -00-00 and NULL as well as a non-zero date in your data model? On 9/30/05, John Siracusa <[EMAIL PROTECTED]> wrote: > On 9/30/05, Uwe Voelker <[EMAIL PROTECTED]> wrote: > > Given

Re: [RDBO] problem with MySQL date and datetime columns

2005-10-02 Thread John Siracusa
On 10/1/05 3:19 AM, Uwe Voelker wrote: >> Yeah, that's one option. Have you tried defining the column like this? >> >> DATUM2 => { type => 'date', not_null => 1, default => '-00-00' } >> >> If that doesn't work, I'll probably try to make it work. > > Unfortunately this doesn't work. RDBO

[RDBO] ANNOUNCE: reboot of Rosetta/SQL-Routine development, in Perl 6

2005-10-02 Thread Darren Duncan
2005-09-30 Darren Duncan <[EMAIL PROTECTED]> -- I would like to acknowledge that, despite all the good things that have come out of it, I have had some significant problems in regards to the past development of my Rosetta rigorous database porta

Re: [RDBO] problem with MySQL date and datetime columns

2005-10-02 Thread Uwe Voelker
Hello John, Yeah, that's one option. Have you tried defining the column like this? DATUM2 => { type => 'date', not_null => 1, default => '-00-00' } If that doesn't work, I'll probably try to make it work. update() - Invalid default date: '-00-00' I would appreciate it if this wor

Re: [RDBO] problem with MySQL date and datetime columns

2005-10-02 Thread John Siracusa
On 10/1/05 11:03 AM, John Siracusa wrote: > On 10/1/05 3:19 AM, Uwe Voelker wrote: >>> Yeah, that's one option. Have you tried defining the column like this? >>> >>> DATUM2 => { type => 'date', not_null => 1, default => '-00-00' } >>> >>> If that doesn't work, I'll probably try to make it