W3C home > Mailing lists > Public > w3c-wai-ig@w3.org > October to December 2003

Re: Date & number format

From: David Woolley <david@djwhome.demon.co.uk>
Date: Fri, 5 Dec 2003 07:25:11 +0000 (GMT)
Message-Id: <200312050725.hB57PBh01801@djwhome.demon.co.uk>
To: w3c-wai-ig@w3.org

> --but David, how would this be entered into a database later on to be
> queried.  At least by specifying that the Month has to be entered in this

Most databases store dates as the number of days (or seconds) since some
particular epoch, so the data entry format is irrelevant.  (SQL Server,
does allow flexible entry of dates in the human interface, although it
is not as flexible as some other software in that respect.)

A sensible database design will also use UTC, rather than wall clock
time, to define the dates.  It is actually the existence of multiple
time zones throughout the world that is the real problem for World Wide
Web date entry, unless dealing with dates of birth, which are 
conventionally given in wall clock time at the place of birth.
Received on Friday, 5 December 2003 02:31:47 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Tuesday, 19 July 2011 18:14:13 GMT