[Dbi-interbase-devel] Timestamp field and timezone

[willems L. <wil...@pa...>]

	Hello ,


if have some tables with timestamp fields. If i do a select query on the 
table , all timestamp fields have 1 hour more than origenal inserted .

i use folowin function to generated the time defenition for the prepare 
statement.

our $dateformat="%d/%m/%Y";
our $timeformat="%T";

sub getdateformat {
  return {
     ib_timestampformat => "$dateformat $timeformat",
     ib_dateformat => "$dateformat",
     ib_timeformat => "$timeformat",
   };
};

...
$sth = $dbh->prepare($query,getdateformat);
...

I think this has to do with some time zone settings , but how can i make sure 
that DBD::interbase uses the local time instead of some GMT time ?

		luc