Barand Posted November 9, 2013 Share Posted November 9, 2013 If you are talking about the DATE field type, then you don't have to change it. BUT, if you don't you'll be forever reformatting it with STR_TO_DATE() in every query that does anything useful with it (comparing dates, sorting by date, using datetime functions etc). For currency fields use type DECIMAL with 2 dec. places defined rather than FLOAT Quote Link to comment https://forums.phpfreaks.com/topic/283570-missing-something-simple-i-just-know-it/page/2/#findComment-1457654 Share on other sites More sharing options...
richei Posted November 9, 2013 Author Share Posted November 9, 2013 Its a varchar right now, seems to work ok though. As long as i don't have to change the data type for the start date, it'll be ok. I'm just worried about the sales import script. it'll be trying to import it as a string though an array. I think i got it formatted in the right place, i'll see soon enough. Quote Link to comment https://forums.phpfreaks.com/topic/283570-missing-something-simple-i-just-know-it/page/2/#findComment-1457658 Share on other sites More sharing options...
Barand Posted November 9, 2013 Share Posted November 9, 2013 Its a varchar right now, Quote Link to comment https://forums.phpfreaks.com/topic/283570-missing-something-simple-i-just-know-it/page/2/#findComment-1457659 Share on other sites More sharing options...
richei Posted November 9, 2013 Author Share Posted November 9, 2013 in my defense, I didnt create the tables. havent had any issues with it though. Quote Link to comment https://forums.phpfreaks.com/topic/283570-missing-something-simple-i-just-know-it/page/2/#findComment-1457669 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.