current time problem

[Anon]

I do an insert into a table with value of CURTIME() and it puts in the (?server current time I guess?)...

I then do a php statement to return the current time
$time = date("H:i:s");

These 2 times are different, by about 19 hours actually...I am using a host service, not my own web server, so I would guess that the option of resetting the time on 1 end or the other would be out of the question...

Is there a way to get the current time from the MySql server. That way if 30 minutes has elapsed since the insert and the present time, it will actually be 30 minutes and not 19 hours,30 minutes.

Thanks

[Anon]

If you want the MySQL server's time, just do the following query:

SELECT CURTIME() AS time

and that will return a table with the column "time", with only one row, the current time.

Diego

[rbenfield]

You should just be able to do a query like...

"SELECT CURTIME()"

Hope that helps,
Richard

[rbenfield]

hehe, I was a little slow with my reply so I had not seen your reply when I read it and replied...

[Anon]

Great, thanks