31,016
edits
Language and development rules: Difference between revisions
Jump to navigation
Jump to search
→Dates and Timezones
| Line 272: | Line 272: | ||
All select methods should translate date fields, that are with format TZ of database ('19700101030000'), into a timestamp field by calling the method db->jdate. This is to store into memory a GTM Timestamp date. All insert methods must convert, during generation of SQL request, the memory date into the string by using db->idate (you may find examples into skeleton). | All select methods should translate date fields, that are with format TZ of database ('19700101030000'), into a timestamp field by calling the method db->jdate. This is to store into memory a GTM Timestamp date. All insert methods must convert, during generation of SQL request, the memory date into the string by using db->idate (you may find examples into skeleton). | ||
* Dates that are updated automatically (field '''tms''' into database) contains a GMT Timestamp GMT of date when change is done. | * Dates that are updated automatically (field '''tms''' into database) contains a GMT Timestamp GMT of date when change is done. The select will also use the db->jdate (that use PHP server TZ) to convert read data into a GMT Timestamp into memory. So if timezone of database differs from timezone of PHP server (one of them is not correctly set), you may experience differences between creation date and update date. | ||
== UTF8/ISO encoding == | == UTF8/ISO encoding == | ||