remote database date time compare with local php date time

[blackhorse]

When I compare with the local php date time with the remote mysql database date time field, I need to consider the time zone difference?

[dagon]

blackhorse;10925631 wrote:

When I compare with the local php date time with the remote mysql database date time field, I need to consider the time zone difference?

if they are in different time zones and your doing time dependent queries, then yes.

[blackhorse]

Thanks!

I used to work with local database, I didn't pay attention to this issue. So that bring me to the new question.

In the most tables, I would have fields called "last_modified", "created" as date time type, for the time of the record created, last modified etc.

So for these two fields, for better practice should I save these two fields as unix timestamp instead of regular date time?

[dagon]

blackhorse;10925636 wrote:

So for these two fields, for better practice should I save these two fields as unix timestamp instead of regular date time?

Theres no single answer, the best type will always depend on the particular situation.