timestamp in orders table when order is successful

Hi,
I have a column in my orders table called date, it is a timestamp. When a customer hits the checkout in the confirm and the order is accepted by paypal, and all of the info is collected in the orders table, I want the date column to have the date using time stamp. This worked at one point and now it is not working. Do I need a record set called orders and then a session variable called date to have this post?
Thank you

What is the value that you are currently inserting into the date column on your confirm page? You will need to ensure that the value you are inserting contains a properly formatted timestamp. When you say 'timestamp' are you referring to a unix style time stamp that is a integer value for the number of seconds or are you talking about a MySQL style timestamp field?

Regardless, you will need to ensure that the value you are inserting has a valid timestamp for the type of column you are inserting into. If you have no value currently setup like this the easiest thing to do would be to add in a session variable that has a value of the current time. You would then reference this session variable in the server behavior for the value of your date column.

I changed the db column to datetime (since this has worked for me in the past and in confirm.php I have it set up to post as: .((isset($_POST["Y-m-d G:i:s"]))?$_POST["Y-m-d G:i:s"]:"")
and this does not work.
Thank you

The way you have the code for the date is not valid. You will need to set a variable to the current date and time in the format you specified like this:

$the_current_time = date("Y-m-d G:i:s");

You would then insert this variable into your db. If you are not familiar with using variables in this way you can add in an extra hidden form element and set it's value the same as above with the date function. Then you can specify this posted element for the time in the db.