Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Date storage issue

Date storage issue

Thread began 4/29/2011 3:36 pm by web_assist_mail157665 | Last modified 5/02/2011 1:19 pm by web_assist_mail157665 | 1475 views | 4 replies

5/02/2011 1:19 pmJason ByrnesWebAssist

In MySQL, a string and date are treated the same. a date is passed the same as a text string in my sql:
'text string'
or
'2011-5-2'

you can get around these date formating issues by using a varchar columns for your dates, a MySQL date column will need to use the yyyy-mm-dd hh:mm:ss format

in a varchar column you can store the more familiar 5/2/2011 format. If you are going to use a data column type, then you will need to reformat the date to the expected format.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.