Jump to content

missing something simple, i just know it


richei

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.