Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.e.g. TIME on mysql, interval on pgsql.
Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.e.g. TIME on mysql, interval on pgsql.
Top Drupal contributor Acquia would like to thank their partners for their contributions to Drupal.
Drupal is a registered trademark of Dries Buytaert.
Comments
Comment #1
Damien Tournoud CreditAttribution: Damien Tournoud commentedI'm I the only one to think that those have no purpose (especially on a loosely typed language like PHP?). Moreover, those are fixed length, which is ugly, and I only had problem with those on some DBMS (ie. Oracle) that assume that date/time types should be locale dependent (both in term of order of arguments AND in timezone).
Comment #2
beginner CreditAttribution: beginner commented+1
http://en.wikibooks.org/wiki/SQL_dialects_reference/Data_structure_defin...
Comment #3
beginner CreditAttribution: beginner commented#200953: Schema API lacks the 'time' and 'date' type
Comment #4
Damien Tournoud CreditAttribution: Damien Tournoud commentedWell, still -1. I don't think we ever need them. DATE and TIME fields are ugly, and we have perfectly working timestamps.
Comment #5
Damien Tournoud CreditAttribution: Damien Tournoud commented