phpBB's storage of time and dates in the database

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
User avatar
smithy_dll
Registered User
Posts: 461
Joined: Tue Jan 08, 2002 6:27 am
Location: Australia
Contact:

Re: phpBB's storage of time and dates in the database

Post by smithy_dll »

You don't even need 64bit computers to do 64bit integer operations, most modern 32bit processors can do them blazingly fast.
Image
phpBB, its open source, become involved, write a modification!
Modifications Database | MOD Development Forum Rules | MOD Studio

hasten
Registered User
Posts: 63
Joined: Mon Mar 31, 2003 7:49 am

Re: phpBB's storage of time and dates in the database

Post by hasten »

Davidls wrote: You don't even need 64bit computers to do 64bit integer operations, most modern 32bit processors can do them blazingly fast.
BigInt?

night.exe
Registered User
Posts: 17
Joined: Sat Jan 29, 2005 11:53 pm
Contact:

Re: phpBB's storage of time and dates in the database

Post by night.exe »

Aren't most processors way more than 64bit anyway? Even Sega's Dreamcast of 1998 had a 128bit processor.
Image
I'm pro-PHP!

hasten
Registered User
Posts: 63
Joined: Mon Mar 31, 2003 7:49 am

Re: phpBB's storage of time and dates in the database

Post by hasten »

night.exe wrote: Aren't most processors way more than 64bit anyway? Even Sega's Dreamcast of 1998 had a 128bit processor.
No, Intel Pentium 4 processors and prior are 32-bit, as well as AMD Athlons. The AMD Opteron and Hammer and 64-bit / x86 compatible. Even Apple's Motorola processors were 32-bit until the G5.

DeadEye686
Registered User
Posts: 448
Joined: Mon Jul 21, 2003 7:18 pm
Contact:

Re: phpBB's storage of time and dates in the database

Post by DeadEye686 »

The Dreamcast did have a 128-bit RISC processor, but it was certainly not the norm. Way ahead of its time.

Uchiha Nick
Registered User
Posts: 397
Joined: Tue Jul 20, 2004 6:21 am
Location: Rotterdam, The Netherlands
Contact:

Re: phpBB's storage of time and dates in the database

Post by Uchiha Nick »

night.exe wrote: Aren't most processors way more than 64bit anyway? Even Sega's Dreamcast of 1998 had a 128bit processor.
wasnt that for graphics?
Image

NeoThermic
Registered User
Posts: 198
Joined: Fri Jan 02, 2004 3:44 pm
Location: United Kingdom
Contact:

Re: phpBB's storage of time and dates in the database

Post by NeoThermic »

Well, here's something that not many people know... windows stores dates as a 64bit int.... but not in any logical way...

Basically it stores a file's date in a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601.

Yes... number of 100 nanosecond intervals since 01/01/1601

*why?!* ;)

NeoThermic
phpBB release date pool!
The NeoThermic.com... a well of information. Ask me for the bit bucket so you can drink its goodness. ||新熱です

User avatar
cyberCrank
Registered User
Posts: 560
Joined: Wed Jan 28, 2004 3:38 am
Location: Ethereal Bliss

Re: phpBB's storage of time and dates in the database

Post by cyberCrank »

the first date of the quadri-century

** so now we can fix the DST issue ;) **

Post Reply