Time Stamp COde

NZ_Kiwi

My server is US based and I'm NZ based. I want to write a code and insert a time stamp to a code, i would like NZ time if I can. Any ideas how this would look?

lilleman

Hi,

Take a look at the setlocale function.

Yours, Erik.

NZ_Kiwi

Originally posted by lilleman
Hi,

Take a look at the setlocale function.

Yours, Erik.

I have never like or been able to understand the PHP website! Are you able to post a small code or something?

TheDefender

If you look at the page for [man]setlocale[/man], and scroll down, you will see example code, and if you go even further, you will see user examples.

NZ_Kiwi

Originally posted by TheDefender
If you look at the page for [man]setlocale[/man], and scroll down, you will see example code, and if you go even further, you will see user examples.

Still have no idea

Let me explain again maybe this is the wrong code.

I'm making a small code which tracks users I need to enter the time the users hits this code into a database, I would like it to be nz time but the server is US based!!

I need the time in a format were I can run a query after getting the time to see if a user on the same IP has been added within the last 10 minutes.

How would I add this time?

lilleman

Hi,

If you know how many hours you need to add/subtract from the server-time, then you should be able to do like this when inserting the time.

INSERT INTO table
(datefield, ...)
VALUES (
  DATE_ADD(NOW(), INTERVAL X HOUR),
  ...
)

You must change X to whatever hours you want to add. If you want to subtract hours from the time, use DATE_SUB instead of DATE_ADD.

Yours, Erik.