Home » Download » Drupal project » Drupal » Issues

Schema doesn't support DATE nor TIME type

Gerhard Killesreiter - April 30, 2008 - 00:20
Project:Drupal
Version:7.x-dev
Component:database system
Category:bug report
Priority:normal
Assigned:Unassigned
Status:duplicate
Description

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

» Login or register to post comments

#1

Damien Tournoud - April 30, 2008 - 06:50

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

Login or register to post comments

#2

beginner - July 2, 2008 - 10:11
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...

Login or register to post comments

#3

beginner - July 2, 2008 - 10:14
Status:active» duplicate

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

Login or register to post comments

#4

Damien Tournoud - July 2, 2008 - 10:14
Status: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.

Login or register to post comments

#5

Damien Tournoud - July 2, 2008 - 10:15
Status:active» duplicate
Login or register to post comments
 
 

Drupal is a registered trademark of Dries Buytaert.