Posted by Jim Carlock on 06/16/07 02:34

"Michael Fesser" wrote...
: What do you want to do actually? What does the Windows Explorer
: have to do with PHP?

Not sure that it has anything to do with PHP. I specifically noticed the
problem with Explorer. Was wondering if it was an OS issue and if
PHP dealt with it in some other way.

And a year or so ago, I extracted a file from a zipped package. The
file was dated a long time ago but when it came out of the archive,
Explorer didn't display a date upon the file. The unpacking program
seemed to handle the file well. Windows Explorer failed, failed though.

I was just playing around with dates trying to figure out how to get
a database to handle dates. I think it'll be pretty easy to use 3 or 4
32-bit integers to represent dates. Only need one to represent the
day of the year, and the other three should provide enough bits to
handle an ancient past. Wondering how many bits are needed to
handle the life of Earth. :-)

Still got some more playing to do. I personally have some files
dating back to about 1990 and earlier (America Online Beta Versions
(DOS), they called it ), and then there are some archived
files dated prior to 1980. The dates after Dec 31, 1979 read fine via
Windows Explorer. I didn't even have a computer until 1982 or 1983
(an Atari 400 and later a hand me down IBM PC Jr with a wireless
keyboard which got bad reviews in the magazines - the keyboard).

Just started wondering about dates and databases. PHP can handle
dates like birthdates dating back to 1890? And what type of database
someone uses to handle prehistoric dates?

The date upon the following file...
Thursday, January 01, 1970, 12:00:00 AM
http://67.8.106.162/
vbsight3a.gif

The date upon the following file...
vbsight.tar.gz
Monday, December 31, 1979, 11:59:00 PM

<shrug> Windows handles the dates okay. Explorer though... :-) Feel
free to download the files and look at the files or whatever. They're
just some gif images. I'm giving them away.

--
Jim Carlock

[Back to original message]