datetime fields?

From: Robert Zeigler (rdzeigl...arizona.edu)
Date: Sat May 14 2005 - 01:01:20 EDT

  • Next message: Andrus Adamchik: "Re: datetime fields?"

    From looking at the modeler, it appears that only date, time, and
    timestamp fields are supported. This is problematic at least in mysql,
    since there is no way to store both a date and time in the same field
    and also allow a null value for that field. (Date fields truncate time
    information, time fields truncate date information, and timestamp fields
    insert the current time if the value is either null or not specified).
    Normally, I find ways to work around this, but I'm dealing with a
    situation where I need both a date and a time, and I also need to allow
    null values. Thoughts?

    Thanks,

    Robert

    This archive was generated by hypermail 2.0.0 : Sat May 14 2005 - 01:01:29 EDT