realtek Posted May 26, 2003 Share Posted May 26, 2003 Hi, I am aware of how to use the update query. However, could someone please advise me of how to update a timestamp field, seeing as the timestamp is automatically generated? Thanks!, Nick Quote Link to comment https://forums.phpfreaks.com/topic/510-update-a-timestamp-field/ Share on other sites More sharing options...
shivabharat Posted May 26, 2003 Share Posted May 26, 2003 As u said time stamp is the value at the point of record insertion. and u can have varying length TIMESTAMP(14) YYYYMMDDHHMMSS TIMESTAMP(12) YYMMDDHHMMSS TIMESTAMP(10) YYMMDDHHMM TIMESTAMP( YYYYMMDD TIMESTAMP(6) YYMMDD TIMESTAMP(4) YYMM u can use something like ( example) this update test set dt=\'20030523203030\' If dont give the correct format u will just see 0000000 being updated So check the value u have given in time stamp! Quote Link to comment https://forums.phpfreaks.com/topic/510-update-a-timestamp-field/#findComment-1698 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.