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? Quote Link to comment 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? Quote Link to comment 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.