JMair Posted March 25, 2009 Share Posted March 25, 2009 Is there a MySQL timestamp on all changes, and if so how do I query that timestamp. If there isn't, can somebody suggest a way to make php add a sortable timestamp? I'm making a site for students to upload files to teahcers, but there needs to be a timestamp on the file for teachers to see if the assignment is in on time or not. Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/151142-solved-mysql-timestamp/ Share on other sites More sharing options...
Mchl Posted March 25, 2009 Share Posted March 25, 2009 http://dev.mysql.com/doc/refman/5.0/en/timestamp.html Quote Link to comment https://forums.phpfreaks.com/topic/151142-solved-mysql-timestamp/#findComment-793973 Share on other sites More sharing options...
Maq Posted March 25, 2009 Share Posted March 25, 2009 There is a timestamp datatype in mysql. If a student modifies their assignment just update the column with the current time. Quote Link to comment https://forums.phpfreaks.com/topic/151142-solved-mysql-timestamp/#findComment-793975 Share on other sites More sharing options...
Mchl Posted March 25, 2009 Share Posted March 25, 2009 TIMESTAMP can actually do it by itself Quote Link to comment https://forums.phpfreaks.com/topic/151142-solved-mysql-timestamp/#findComment-793978 Share on other sites More sharing options...
JMair Posted March 26, 2009 Author Share Posted March 26, 2009 Good stuff. THanks guys. Quote Link to comment https://forums.phpfreaks.com/topic/151142-solved-mysql-timestamp/#findComment-794594 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.