[PHP] Dates and different time zones

2007-04-10 Thread Niklas Karlsson
() to Europe/Stockholm, and all dates that is saved into the database is timestamp with time zone (using PostgreSQL). So a wonder who to handle different time zones? Have any of your experience of this? Cheers Niklas Karlsson

RE: [PHP] Dates and different time zones

2007-04-10 Thread Niklas Karlsson
Thanks for good answers. Okay, so I should set the default time zone to central GMT time, and then save GMT offset for every user. This sounds realistic, because I don't think that I need to correct the time for users that doesn't login. So, if I now have the GMT offset for every user, how do I

[PHP] Need sql-editor

2007-01-31 Thread Niklas Karlsson
Hello everyone I need a good sql-editor where I can write sqlcode. The problem is that I don't have rights to list tables, functions and so on. Now I use EMS Sql Manger 2005, and if I want to write and execute sqlcode I need access to the system tables, and I don't have it on this database.

SV: [PHP] Need sql-editor

2007-01-31 Thread Niklas Karlsson
Niklas Karlsson wrote: Hello everyone I need a good sql-editor where I can write sqlcode. The problem is that I don't have rights to list tables, functions and so on. Now I use EMS Sql Manger 2005, and if I want to write and execute sqlcode I need access to the system tables, and I