I've written a patch for Drupal 7 to enable date and time data types to be defined for the schema API.
There seems to be some resistance to this idea due to concerns about compatibility between database versions (Drupal now supports MySQL, PostgreSQL and sqlite).
Personally I don't think Drupal can afford to work at lowest common denominator level if the aim is to be a serious option for the enterprise
