time zone offset

[Stan]

Is there a way to change the time zone offset to write to MySQL from Dadabik a different time and account for daylight saving time as well? Problem is I live in Mountain Standard Time and my server is in Eastern Standard Time, 2 hours later than I. Now when my users insert a record here the time written to the database is two hours later than the insert time, which for my project is unacceptable. Alternately, is there a way to do time offset in PHP or MySQL directly?

Thanks,
Stan

 

[Eugenio]

Stan wrote:
>
> Is there a way to change the time zone offset to write to
> MySQL from Dadabik a different time and account for daylight
> saving time as well? Problem is I live in Mountain Standard
> Time and my server is in Eastern Standard Time, 2 hours later
> than I. Now when my users insert a record here the time
> written to the database is two hours later than the insert
> time, which for my project is unacceptable. Alternately, is
> there a way to do time offset in PHP or MySQL directly?

I think it is possible to modify a date time according to the time zone offset by using the PHP date() functions. Look at the PHP manual.

If it's possible, than you have to modify the DaDaBIK code, in particular the behaviour of the "insert_date" case.

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)