Yes MySQL appears to allow that (and hopefully PostgreSQL will too). Thanks!
I guess that will do as a workaround without any change to MODS. For some
reason I thought the DB would reject a date like that. Apologies for the
confusion, this will work nicely.
On 30/4/07 11:48 PM, "Ray Denenberg, Library of Congress" <[log in to unmask]>
> From: "Christiaan Kortekaas" <[log in to unmask]>
>> The reason I can't just supply 2007-02 is because in the backend MODS is
>> being indexed in a relational database in a 'datetime' field which even if
>> you insert '2007-02' would store it as '2007-02-01'. It is necessary to
>> store it as a datetime field so I can do datetime sorting, searching etc.
> Would it be possible to store it as 2007-02-00? (Or 2007-02-99 depending on
> whether you want it sorted at top or bottom.)
Senior Library Systems Programmer
Library Technology Service
The University of Queensland, Australia QLD 4072
Telephone : (+61) (7) 3346 4337