Actually, there is a way to do this in a client-server app, but as Stan
said, it requires extra work in the application...

In Image/SQL, create a stored procedure which executes the insert or update.
The column which contains the DATETIME field would be completed by the
stored procedure.

An offset is stored in a table or dataset, either User driven or Location
Driven.  When the application is started on the PC - get this record.  The
offset is stored as an Integer (signed numeric in Image/SQL).  This can be
applied using standard time functions in the application where needed - but
again, it's the stored procedure which writes the data to the dataset or
table.

We've done it this way on a couple of projects, where timezones were a
problem.  It works out nicely.  The data comes down with a "standard time",
and the offset is applied to it, to create a "display time".

HTH,
Joe

====================================================
Joe Geiser, President and Senior Partner
CSI Business Solutions, LLC
Phone: +1(215) 945.8100   Fax: +1(215) 943.8408
Toll Free (US/Canada): (877) 945.8100
====================================================