griffin
Member
Hi All
I feel a little silly here but what Data Type should a Date element be set to on the server? It seems obvious but for some reason when looking at my tables on the server via phpMyAdmin I get some Date elements that have Type as VARCHAR where others are set to DATETIME. Does it have anything to do with changing the format to 'd-m-Y'?
I assumed when creating the element that Fabrik would magically set the Type to the appropriate one - which for a Date element would presumably be DATE or DATETIME (not VARCHAR). This appears to not always be the case for some strange reason.
So my questions are:
1. Should all Date elements be either Type = DATE or DATETIME?
2. Should I change the Type on the server?
3. Will changing the Type on the server cause any data loss or other problems?
4. If changed will it update all records automatically in that table?
5. Also, where I have a Date element and I don't want to show the time - just 'd-m-Y' - should that Type be set to DATE rather than DATETIME?
Cheers
I feel a little silly here but what Data Type should a Date element be set to on the server? It seems obvious but for some reason when looking at my tables on the server via phpMyAdmin I get some Date elements that have Type as VARCHAR where others are set to DATETIME. Does it have anything to do with changing the format to 'd-m-Y'?
I assumed when creating the element that Fabrik would magically set the Type to the appropriate one - which for a Date element would presumably be DATE or DATETIME (not VARCHAR). This appears to not always be the case for some strange reason.
So my questions are:
1. Should all Date elements be either Type = DATE or DATETIME?
2. Should I change the Type on the server?
3. Will changing the Type on the server cause any data loss or other problems?
4. If changed will it update all records automatically in that table?
5. Also, where I have a Date element and I don't want to show the time - just 'd-m-Y' - should that Type be set to DATE rather than DATETIME?
Cheers