Forum OpenACS Development: template::util::date::get_property returns invalid dates when full date is not specified

Collapse
1: template::util::date::get_property returns invalid dates when full date is not specified
Posted by Dave Bauer on 03/04/04 04:06 AM
In postgresql, at least, inserting '2004' into a date or timestamp column will end up with the value '2004-01-01 00:00:00' being stored in the database.

If the form-builder date datatype is used with the to_sql option set to sql_date or ansi '2004-00-00 00:00:00' is returned. Postgresql does not accept this date.

I want to change the template::util::date::get_property to return 01-01 for missing date elements instead of 00-00.

Any objections? This looks like a small oversight. Am I missing anything here?

Collapse
2: Re: template::util::date::get_property returns invalid dates when full date is not specified (response to 1)
Posted by Jun Yamog on 03/04/04 03:14 PM
No objections.  You might want to do a quick check on Oracle after the fix.