The easy way to use this more elegant approach of mr.nick would be to INSERT using the MySQL helper function:     INSERT INTO x (y) VALUES (FROM_UNIXTIME(?)); You might want to check out 7.4.11 of the MySQL docs for more detailed information.