question

brailleschool

The time is now 1:23AM and I edited my code to insert the time into the mysql database.

This is what I am using:

$date=date('m-d-Y H:i:s');

When I viewed the screen to see what it had, this is what it said:

05-30-2004 22:19:38

I can see that the date is correct, but the time is not. Is this because it is maybe the server time?

How am I able to print the exact time the entry was made into the mysql database?

Please advise if you can... thanks.

noimad1

The date function does use the server time.

Is this a local server, or are you hosting this somewhere?

Is the time always off? If you echo out the exact time with a script, is for sure incorrect time?

Maybe what you could do is this:

Echo out the exact time of the server, and at the same time take note of your local time.

Find out the difference between the two, and then just write in your function to add/subtract the difference to the server time before you write it to your database.

Kind of a cheesy way to do it, but it would work.

brailleschool

Originally posted by noimad1
The date function does use the server time.

Is this a local server, or are you hosting this somewhere?

Is the time always off? If you echo out the exact time with a script, is for sure incorrect time?

Maybe what you could do is this:

Echo out the exact time of the server, and at the same time take note of your local time.

Find out the difference between the two, and then just write in your function to add/subtract the difference to the server time before you write it to your database.

Kind of a cheesy way to do it, but it would work.

I am located in New York, and I have no clue where they are, but according to my hosting companies site, they use PST where I use EST. I was just wondering if the time could be the exact time of where the sender is located. I would expect this might not be possible right?

Also, how would I inform the recipient that its AM or PM for the time? I would expect I would have to add something to the time code. I am totally new to php, so all the help I can get is most appreciated.

LordShryku

You could also use [man]putenv[/man] to set the timezone to use.

noimad1

I wouldn't think that you would want to use the users time becuase then you would have to log their time zone so you know...unless that doesn't really matter and you just want the information for statistics purposes.....like what time most users add information to users....or if you wanted to display that info to the user...

For am/pm you can use a "a" or "A" in your date function call:

$date=date('m-d-Y H:i:s a');

brailleschool

i dont mind logging their timezone in their stats. shouldnt be too much of a problem. just wondering how you would code that little function to check the persons time zone to add or minus the certain amount from the server time. what happens if the users time zone is the same as the servers time zone... in this instance?

thanks so much for your speedy replies.