Download & Extend
Issues

Schema doesn't support DATE nor TIME type

Posted by Gerhard Killesreiter on April 30, 2008 at 12:20am
Project:Drupal core
Version:7.x-dev
Component:database system
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (duplicate)

Issue Summary

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

Login or register to post comments

Comments

#1

Posted by Damien Tournoud on April 30, 2008 at 6:50am

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

#2

Posted by beginner on July 2, 2008 at 10:11am
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...

#3

Posted by beginner on July 2, 2008 at 10:14am
Status:active» closed (duplicate)

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

#4

Posted by Damien Tournoud on July 2, 2008 at 10:14am
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.

#5

Posted by Damien Tournoud on July 2, 2008 at 10:15am
Status:active» closed (duplicate)