[TYPO3-english] Converting DATE to INT

Jigal van Hemert jigal at xs4all.nl
Sat Nov 14 09:01:15 CET 2009

Hi Andi,

Andreas Becker wrote:
> Does anybody know a way to CONVERT the DATE to INT so that the typo3 value
> will be available again in the database for the extensions to be used.

Assuming that you already found that the MySQL DATE format has a much 
larger range than a UNIX timestamp (the INT you refer to) and that the 
dates are all in the range of a timestamp, you can easily convert them 
using a small query with the UNIX_TIMESTAMP() function.
UPDATE `table1` SET `intcolumn` = UNIX_TIMESTAMP(`datecolumn`);


Regards, Jigal.

More information about the TYPO3-english mailing list