Comment 16 for bug 918257

Hi,

(my related issue here https://bugs.launchpad.net/openobject-server/+bug/1012501)
Based on comment #4 by Olivier, here are 2 issues (not related to create/write date):

1. My local timezone is GMT+7 (Vietnam).
- I set local time for host environment (which openerp-server runs in) is 03:00:00 (AM).
- openerp-server results in "2012-06-12 20:00:00" (posting date field). Its behavior is as design specs. (posting date is written automatically with strftime() when pressing 'Post' button)
- But when in search view, I do search posting date with value of today (2012-06-13). Search results do not contain this record. But value of (2012-06-12), it includes this record.

2. the second related to SQL queries. When executing cr.execute() with some conditions on date field (posting date as above), it does wrong, as above. Besides, if I use SQL queries outside openerp-server environment. It's really serious. What should I do in this case? I think by some means, date stored in DB must be in localtime zone.

Thanks,