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"? Quote 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. Quote 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? Quote 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. Quote 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! Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.