I am developing a large PHP application that is being served on multiple
servers for clients who are in different timezones. There are a number of
Timestamp fields in my tables, and some are set in triggers on the server.

I am trying to store all Timestamps in UTC, so that I can convert them to
the native Timezone of the user however that is fine with Timestamps that
I'm controlling in PHP, but I can't seem to see a way to convert the 'system
date/time' of the server in Firebird to UTC in a trigger when the data is
being created on the server for the user automatically in FB.

Any ideas on how to do this?

Myles


============================
Myles Wakeham
Director of Engineering
Tech Solutions US, Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
www.techsol.org