mysql code help -- now() function

Is there anyway to convert something like ::

to something a bit more server/worldly friendly?

I’m working on some code but I can’t for the life of me figure out how I can fiddle with the code so that I could do something like:

$my_now = now() + 9 hours;



At the moment I’m working on a private project but what gets solved here will definitely show up later !
I promise .... scouts honor .... hehe, a teaser line.

Piece of cake! (Chocolate please )

http://us3.php.net/strtotime

I thought carsten want a function for MySql itself, instead of PHP, isn’t it?

Anyway if you want MySql, here is the sql query.


Honestly, I don’t really get the question, but I hope my suggestion and mark’s will be usefull to you.

COOL!

Need the code for a mysql call rather than php.

Problem is that my server is in Vancouver and I live in Japan. +9 hours

So if you just do simple mysql now() inserts you get stuck with the server setting rather than the "virtual" site setting.

Now is this possible to set on a domain basis? like in .htaccess or something ?

Or could I do :

php putenv( "PHP_TZ=ASIA/TOKYO" );

Could this overide for the domain or would it likely blow a fuse in the server?



do we have this in MODx
doh, I really should check things like this more often!

Thanks guys and gals

My suggestion will be using a php to detect the ip address using free ip checking and decide the time zone, and in your php code you will need to add/subtract the current server time that you use.

As for community base website, you can set this as a setting and all you need to do just read the setting of the time zone that your users have, which is a lot easier to implement that detecting their ip address.

Hope it helps again...