datetime need more abstraction
hswong3i - November 21, 2007 - 16:11
| Project: | Drupal |
| Version: | 7.x-dev |
| Component: | database system |
| Category: | bug report |
| Priority: | critical |
| Assigned: | hswong3i |
| Status: | duplicate |
Jump to:
Description
As D6 schema API introduce abstraction for datetime:normal data type, this will introduce more complicated cross database compatible problem.
Refer to document from ADOdb (http://phplens.com/lens/adodb/tips_portable_sql.htm), time related abstraction require around 6 functions/operators. Without similar helper functions as ADOdb, our existing format_date() maybe a much portable solution. Should we rather REMOVE the datetime abstraction, or complete our abstraction level with better support?
#1
(This is part of my personal research project Siren's issue.)
#2
#3
How is this related to #200953: Schema API lacks the 'time' and 'date' type ?
#4
may I point everyone towards:
ISO8601: Numeric representation of Dates and Time
Wikipedia: http://en.wikipedia.org/wiki/ISO_8601
Summary from ISO: http://www.iso.org/iso/support/faqs/faqs_widely_used_standards/widely_us...
Full document (zip-pdf, 228KB): http://isotc.iso.org/livelink/livelink/4021199/ISO_8601_2004_E.zip?func=...
how about a varchar field that simply stores the ISO date and/or time
#5
@beginner #200953 has more information, so marking this as duplicate of that