Round timestamp to nearest day (midnight)

[Mutley]

I have a date formatted like this:

 

Year-Month-Day

2009-03-08

 

When I convert it to timestamp (using strtotime) I want it to round it to that days midnight. It gets the day/month/year correct but adds a random hour (which I don't understand as I've not specified an hour for the timestamp).

 

Any ideas?

 

Thanks in Advance,

Nick.

 

[menriquez]

by "converting to timestamp" i am guessing you mean using the value in a mysql database??  if so, the raw date format for mysql is yyyymmddhhmmss, which means that if you are loading a datetime/timestamp field into a database, convert the field to..

 

20070307000000

 

before the insert...to round the date the easiest way to do that is to add 12 hours to the current time (military time), and if over 24 then add a day to your date field.

 

hope this helps

- mark

[Mutley]

Don't think I understand,

 

It's a UNIX Timestamp.

[Mchl]

It gets the day/month/year correct but adds a random hour (which I don't understand as I've not specified an hour for the timestamp).

 

What makes you think so?

 

<?php
echo date("Y-d-m H:i:s",strtotime("2009-03-08"));
?>

 

echoes: 2009-08-03 00:00:00

[Mutley]

When I do:

 

 

<?php
$date='2009-03-15';
echo strtotime("$date");
?>

 

I get:

 

1237093200

15 Mar 2009 05:00:00 GMT

[Mchl]

Check your time zone settings. Remember, that unix timestamp is always in GMT.

[PFMaBiSmAd]

strtotime() produces a Unix timestamp that corresponds to the date/time it is supplied with in the current time zone. date() converts the timestamp it is supplied with back to a date/time in the current time zone. Each different time zone will give a different Unix Timestamp for the same supplied date/time. These conversions into/out of a Unix timestamp also produce unexpected values due to DST changes and if your DST database is not up to date with any change in DST start/stop dates.

 

What code are you using to produce the 15 Mar 2009 05:00:00 GMT value? The timestamp you get in your timezone for midnight will produce the corresponding date/time in GMT if your time zone is not GMT.

 

And what are you trying to do, because it is likely there is an easier way that will avoid the use of a Unix timestamp and the problems of converting to/from it?