in reply to $hour_insert_sth->execute showing error

change the schema of creation_date to :
creation_date datetime NOT NULL DEFAULT NOW(),
then you don't need to specify it as a '?' parameter or now() in your code,as it's going to be automatically filled for you