[DB-SIG] Date-time types

[Thomas Marsh]

Perhaps there is need to develop a separate internationalization module
for this and other region specific domains. This is how Sybase manages
this issue and it would be an excellent core python module. Regardless
of what standard there is, an order by clause will use whatever date
ordering the database implements, of course.

Lacking an i18n module, I would have to agree that the date time type
should conform as much as possible to the time module in this respect
(0=monday).

(I'm jumping in on this discussion a little late I'm afraid.)

--thomas

Fredrik Lundh wrote:
> 
> >The time module uses 0 as monday, 1 as tuesday,... should
> >the tuple-method of the new type also use this convention,
> >or rather stick to what the C lib does (0=sunday,1=monday,...)
> >which -I think- is ISO standard ?
> 
> ISO C, perhaps.  Not the date/time representation standard
> ISO 8601, which say:
> 
>     A week starts with Monday (day 1) and ends with Sunday (day 7).
> 
> (IMO, rather than letting the week start on a sunday, use Python's
> standard convention 0=monday...)
> 
> And never write date/time code without taking a careful look at ISO 8601
> and related ISO standards.  The following link might be useful:
> 
>     ftp://ftp.informatik.uni-erlangen.de/pub/doc/ISO

-- 
Thomas Marsh                      thomas.marsh@tivoli.com
Tivoli Systems, Inc.              (512) 436 8643

_______________
DB-SIG  - SIG on Tabular Databases in Python

send messages to: db-sig@python.org
administrivia to: db-sig-request@python.org
_______________