[ic] Setting correct timestamp

[Ed LaFrance]

At 01:19 PM 02/18/2002 +0100, you wrote:

>Hallo list,
>Does anyone know how to get the correct timestamp for the order transactions.
>I would like the time adjusted to local time and not using the time from 
>the server.
>I have set the postgresql runtime variable to the correct time zone, and 
>if I do a "select current_timestamp as today;" postgresql gives the 
>correct local time, but Interchange still update the transaction table 
>with the local time of the server.
>Any suggestions please.
>Regards,
>Kim Christensen

I am assuming when you say "local time", you mean the correct time zone for 
the store owner, NOT the time zone of the customer placing the order.  In 
that case, you need on look at the tag ref for the [time] tag:
http://interchange.redhat.com/cgi-bin/ic/docfly.html?mv_arg=ictags04.75

..take a look at the sections on the 'adjust' and 'tz' (time zone) 
parameters - one of those should work for you.  WRT getting an adjusted 
time into an SQL database, you'll want to set the field type to CHAR and 
write the timestring using the [time] tag rather than using fieldtype 
timestamp.

- Ed L.



===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================