e.g. TIME on mysql, interval on pgsql.

Comments

damien tournoud’s picture

damien tournoud commented

I'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).

beginner’s picture

beginner commented
Title: Schema doesn't support TIME type » Schema doesn't support DATE nor TIME type

+1
http://en.wikibooks.org/wiki/SQL_dialects_reference/Data_structure_defin...

beginner’s picture

beginner commented
Status: Active » Closed (duplicate)

#200953: Schema API lacks the 'time' and 'date' type

damien tournoud’s picture

damien tournoud commented
Status: Closed (duplicate) » Active

Well, still -1. I don't think we ever need them. DATE and TIME fields are ugly, and we have perfectly working timestamps.

damien tournoud’s picture

damien tournoud commented
Status: Active » Closed (duplicate)