[TYPO3-dev] It works! Storing non-UNIX dates

David Bruehlmeier typo3 at bruehlmeier.com
Thu Jun 1 21:51:55 CEST 2006


Hi,

sometimes, there is the need to be able to store dates outside of the 
UNIX-timerange, e.g. for birthdates. This has been discussed a few times 
before, and I now implemented a proof-of-concept extension using the 
ADOdb Date Library. ADOdb is shipped as a system-extension with every 
TYPO3 implementation.

It works using two hooks:
1. In TCE-Main, the date entered is converted to an int64 value before 
it is stored in the database.
2. In TCE-Forms, the date is converted back when loaded from the 
database before displayed in the Backend.

If anyone is interested, here's the test-extension:
http://www.feg-duedingen-freiburg.ch/fileadmin/spec/T3X_test_ext_dates-0_0_0-z-200606012135.t3x

Any feedback is appreciated!
Dave




More information about the TYPO3-dev mailing list