Posted by Michael Fesser on 06/15/07 23:21

..oO(Jim Carlock)

>(1) Does PHP provide any way to handle dates prior to 1980?

The beginning of the Unix epoch is 1970.

Recent PHP versions (>= 5.1.0) support negative timestamps, which allows
for dates between 1901 and 2038.

>(2) I'm looking for for ways to store dates and process dates (dates only).
>This probably ends up as a database specific issue, so I'm wondering
>about handling dates (YYYY.MM.DD format) with databases.

Most databases have their own date types. In MySQL for example dates are
stored as YYYY-MM-DD in special DATE or DATETIME columns.

>I don't
>have any experience involving this, and the database I'm playing with
>currently offers no date support at all (SQLite)... and from what I've
>played with in the past, Windows tends to convert dates back and forth
>between text and a number (causing a problem with dates prior to 1980
>specifically with Windows Explorer).

What do you want to do actually? What does the Windows Explorer have to
do with PHP?

Micha

[Back to original message]