I have tried to Google this so I didn't have to ask, as i'm sure this is a simple task...
I am building an E-commerce site and would like to add the date and time a product is added into the product database?
Apologies if this is simple, but i have researched everywhere else first.
Thanks
This can just be part of your database architecture:
ALTER TABLE `products` ADD `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
This will automatically add a timestamp to the column created whenever a row is created. For more information, try this: Automatic Initialization and Updating for TIMESTAMP
Obviously, in this case the table is called products and you would need to change it to whatever your table name is.
UPDATE To update all existing records at the same time, just run:
UPDATE `products` SET `created` = NOW()
If you want to be more specific use:
UPDATE `products` SET `created` = NOW() WHERE `created` = '0000-00-00 00:00:00'
Method1 : Pass the Current DateTime as parameter to the Insert
Method2: Set the default value for the date time column in Product table