Default showing as NULL

Brought to you by: lorenztextor, skrysakj

#3 Default showing as NULL

Milestone: Verified

Status: open-later

Owner: Lorenz Textor

Labels: Data/Content (4)

Priority: 5

Updated: 2003-09-20

Created: 2003-06-27

Creator: Anonymous

Private: No

From roddie@myword.co.uk

Default values of 0000-00-00 00:00:00 for a datetime field
showing in the list as NULL.

CocoaMySQL v0.4, Mac PBG4, OS X (10.2.3)

I've checked the table in Terminal and it is OK. This seems
to be a bug in the way the value is displayed.

Discussion

Lorenz Textor - 2003-08-16

Logged In: YES
user_id=557461

In the current version, dates are stored in Cocoa date objects. This
objects doesn't allow non existing dates like 0000-00-00.
This will be fixed in version 0.6.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

J - 2003-09-11

assigned_to: nobody --> lorenztextor

labels: --> Data/Content

status: open --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

J - 2003-09-11

status: closed-fixed --> open-later
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

J - 2003-09-20

milestone: --> Verified
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Lorenz Textor - 2003-10-11

Logged In: YES
user_id=557461

In version 0.5 dates like 0000-00-00 work. There are still
problems with dates like 0000-01-01 which will be fixed in version
0.6.
If anyone needs a fixed version before, please contact me by
mail!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Steven Palm - 2004-11-01

Logged In: YES
user_id=209930

Any timeline for version 0.6 ?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Nobody/Anonymous - 2004-11-21

Logged In: NO

I hope to release v0.6 soon. It will include some bugfixes, user
contributions and probably support for MySQL 4.1.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.