As I recall, a timestamp column in MSSQL is used by the DB to resolve concurrency issues, and is updated automatically whenever the row is inserted or updated. It is an ever increasing number that is not recognizable or useful as a calender date. You may be able to insert GetDate() since internally dates are numbers, but it may not be doing what you think.
>At 12:04 AM 11/22/2004, you wrote: > >>Thanks for that -works a treat ! > >De nada! > > >-- >Phillip Beazley >Onvix -- Website Hosting, Development & E-commerce >Visit http://www.onvix.com/ or call 727-578-9600. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185032 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
