bschultz Posted May 22, 2011 Share Posted May 22, 2011 What if I don't know what time something is going to be? How can I insert a "TBA"? Link to comment https://forums.phpfreaks.com/topic/237159-tba-in-mysql-time-column/ Share on other sites More sharing options...
Pikachu2000 Posted May 22, 2011 Share Posted May 22, 2011 You cannot insert 'TBA' into a DATE/DATETIME field. You can however, set the time and/or date to zeros, and interpret that to represent TBA. Link to comment https://forums.phpfreaks.com/topic/237159-tba-in-mysql-time-column/#findComment-1218859 Share on other sites More sharing options...
bschultz Posted May 22, 2011 Author Share Posted May 22, 2011 But isn't 00:00:00 midnight? Link to comment https://forums.phpfreaks.com/topic/237159-tba-in-mysql-time-column/#findComment-1218861 Share on other sites More sharing options...
fenway Posted May 22, 2011 Share Posted May 22, 2011 This screams out for "NULL". But isn't 00:00:00 midnight? Not if the date is zero too. Link to comment https://forums.phpfreaks.com/topic/237159-tba-in-mysql-time-column/#findComment-1218874 Share on other sites More sharing options...
bschultz Posted May 23, 2011 Author Share Posted May 23, 2011 The column is TIME...but I hadn't thought of NULL. Thanks! Link to comment https://forums.phpfreaks.com/topic/237159-tba-in-mysql-time-column/#findComment-1218895 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.