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 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! Link to comment https://forums.phpfreaks.com/topic/510-update-a-timestamp-field/#findComment-1698 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.