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?

Comments

hswong3i’s picture

hswong3i commented

(This is part of my personal research project Siren's issue.)

hswong3i’s picture

hswong3i commented
Title: DB compatibility: datetime need more abstraction » datetime need more abstraction
beginner’s picture

beginner commented

How is this related to #200953: Schema API lacks the 'time' and 'date' type ?

alexanderpas’s picture

alexanderpas commented

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

catch’s picture

catch
he/him
Primary language English
commented
Status: Active » Closed (duplicate)

@beginner #200953 has more information, so marking this as duplicate of that