SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:40 PM
| ||||
| ||||
 Adding a time stamp to the records I have a shopping cart that will get full from time to time because customers click out of the site before they confirm their purchase, therefore leaving a full cart behind. I'd like to have a timestamp on this table, so that I can delete anything that I find is more than a day old. How can I do this? Thanks, Bill *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!      |
|
02-28-2008, 05:40 PM
| ||||
| ||||
| Re: Adding a time stamp to the records Hi You could use a not null datetime field and specify the default as getdate(). This will insert the current date/time when the record is created. and you will not have to specify a value. You can then run a scheduled task (job) that checks for entries older than a given date. John "Bill" <BillZimmerman@gospellight.com> wrote in message news:3f4fe28e$0$62083$75868355@news.frii.net... > I have a shopping cart that will get full from time to time because > customers click out of the site before they confirm their purchase, > therefore leaving a full cart behind. I'd like to have a timestamp on > this table, so that I can delete anything that I find is more than a day > old. > > How can I do this? > > Thanks, > > Bill > > *** Sent via Developersdex http://www.developersdex.com *** > Don't just participate in USENET...get rewarded for it! |
Linear Mode
