in reply to How do you format dates for entry into MySql?

you dont have to convert
mysql does it for you! 
$SQLstatement = «ENDSQL
INSERT INTO table (datetime)
VALUES            ('FROM_UNIXTIME($time)')
ENDSQL

[download]

In Section Seekers of Perl Wisdom