basballguy Posted November 30, 2010 Share Posted November 30, 2010 ok so i have a column that stores minutes:seconds in MM:SS format. I tried using the date field but couldn't figure it out so i just dumped it into varchar. Now i want to convert it this time format because i can't sort by it in varchar. So my question is what's the correct field type i should be using to have MM:SS and can i convert it without losing the current value? Link to comment https://forums.phpfreaks.com/topic/220259-converting-field-type-without-losing-value/ Share on other sites More sharing options...
requinix Posted November 30, 2010 Share Posted November 30, 2010 You thought of DATE but didn't think of TIME? Link to comment https://forums.phpfreaks.com/topic/220259-converting-field-type-without-losing-value/#findComment-1141480 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.