[TYPO3-english] Converting DATE to INT
ab.becker at web.de
Sat Nov 14 10:08:37 CET 2009
This helped a lot
On Sat, Nov 14, 2009 at 3:01 PM, Jigal van Hemert <jigal at xs4all.nl> wrote:
> 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.
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
More information about the TYPO3-english