phpBB's storage of time and dates in the database
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!
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!
- 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
You don't even need 64bit computers to do 64bit integer operations, most modern 32bit processors can do them blazingly fast.
phpBB, its open source, become involved, write a modification!
Modifications Database | MOD Development Forum Rules | MOD Studio
Re: phpBB's storage of time and dates in the database
BigInt?Davidls wrote: You don't even need 64bit computers to do 64bit integer operations, most modern 32bit processors can do them blazingly fast.
Re: phpBB's storage of time and dates in the database
Aren't most processors way more than 64bit anyway? Even Sega's Dreamcast of 1998 had a 128bit processor.
Re: phpBB's storage of time and dates in the database
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.night.exe wrote: Aren't most processors way more than 64bit anyway? Even Sega's Dreamcast of 1998 had a 128bit processor.
-
- Registered User
- Posts: 448
- Joined: Mon Jul 21, 2003 7:18 pm
- Contact:
Re: phpBB's storage of time and dates in the database
The Dreamcast did have a 128-bit RISC processor, but it was certainly not the norm. Way ahead of its time.
-
- 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
wasnt that for graphics?night.exe wrote: Aren't most processors way more than 64bit anyway? Even Sega's Dreamcast of 1998 had a 128bit processor.
-
- 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
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
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. ||新熱です
The NeoThermic.com... a well of information. Ask me for the bit bucket so you can drink its goodness. ||新熱です
- 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
the first date of the quadri-century
** so now we can fix the DST issue **
** so now we can fix the DST issue **