i need help creating an enddate column for expiry
my startdate is a datetime and want the enddate to be a datetime,too.
the startdate is automatic(created by mysql on the fly with every submission,so i dont have a maual input to build on)

in php

$startdate=date("Y-m-d H:i:s");

in mysql
`startdate` datetime NOT NULL default '0000-00-00 00:00:00',
`enddate` datetime NOT NULL default '0000-00-00 00:00:00',

thank you for your help