ytoro
|
| Posted: 03/07/2003, 7:41 PM |
|
i was reading that mysql accepts dates only in the yyy/mm/dd format!
do i have to stick to that and format dates on the pages or can i set the date format used globaly in the project?
i am new to php/mysql, i ve been using asp/msaccess. the rules are different.
ytoro
|
|
|
 |
Brandon
|
| Posted: 03/08/2003, 5:48 AM |
|
Everyone else correct me if any of this is wrong but based on about a half day's work fighting with this issue:
1. Start by making sure you MySQL date format is correct (verify against MySQL data): Project:Settings:Connections, choose your DSN, Modify:Server:Date Format
Also, I am pretty sure you will want to stick to using MySQL datetime data type vs. date (based on some of my struggles). So it will probably be: yyyy-mm-dd HH:nn:ss
2. Go back to Project:Settings:Project and you should be able to use any of the date formats that are indicated using the y m d H n s syntax AND you can type in your OWN combination. The Long/Short date and time things didn't work for me. This is just your default date format. Anytime you specify date format for a control you can alter the format that you want to use with the y m d H n s syntax options.
Finally there appears to still be a bug in the common.php file that will incorrectly assign day names to some dates, see: http://www.gotocode.com/disc_viewt.asp?mid=13864
|
|
|
|
|
