MikeW <[EMAIL PROTECTED]> writes: > > jonwood <[EMAIL PROTECTED]> writes: > >> Greetings, >> ... >> Is there ANY way to override this behaviour? Or must I simply initialize all >> such fields explicitly if I would like to set it to the current date in my >> particular time zone? >> >> Thanks. > ... > > Using UTC in the DB stops you going mad when something happens > on the DST changeover (localtime hours vanish, or happen twice), > or you have systems running in or across different countries. > > It also means you can subtract two times and always get the right answer > for elapsed time ! > > Regards, > MikeW
That said, MySQL does provide both CURRENT_DATE/TIME and UTC_DATE/TIME ... http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html I believe in reading around ! MikeW _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
