Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL update for datetime fields


LeeH

Recommended Posts

Can someone please give me the SQL command to update a date field? I update my products using an Excel import, but the datetime stamp aways gets screwed up, so all my products show up as new. I tried

UPDATE products set PRODUCTS_DATE_ADDED = 2003-11-18 09:27:50

but that wasn't quite right. And putting ' ' around the date only updated 2 records, but overwrote real dates with an empty date field.

 

Thanks. I'm getting rusty...

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...