all,use timestamp_col = timestamp_col in your query, to override the NOW() affect.
I just passed by this comment this morning http://www.mysql.com/doc/en/DATETIME.html -- user comments at bottom of page....
hth
Jeff
thanks for your help! sorry i missed the thread this morning, it's hard to have an eye on all the lists :-(
good to know what timestamp was originally meant to do, very useful functionality of course (if one knows how it works!).
thanks again,
henning
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]