I wasn't aware of the ODBC datatype. Good question. Answer was obvious after the following worked:
DECLARE @ts timestamp, @dt as datetime
set @dt = {ts '2008-09-21 15:53:00'}
But, does the timestamp update from the code above? If not, how would this work?