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