Manipulating Dates

[tomalatski]

Greetings,

I have agonized about this problem for some time now. Can I have some help please. I am developing a database system using php4, MySql 3.something, Apache on a Windows platform but will be transforming the product to either Unix or Linux.

This is a database that captures things happening over a 24 hour period however the "day" starts at 07:00 hrs and continues until 06:59 the next day. So anything before 07:00 hrs must show the previous day. Are you with me so far.

I have looked through the posts and apart from using Unix time stamps nothing seems to fit. I originally developed this system in MS Access with a quick IF statement i.e. if time < 07:00 then Date() = Date()-1.

Can I perform a similar function either with php or MySql?

Please help - cheers.

Tomalatski

[devinemke]

<?php
$date_time = '2004-11-27 09:35:00'; // just for testing

$timestamp = strtotime($date_time);
$date_timestamp = strtotime(date('Y-m-d', $timestamp));
$diff = $timestamp - $date_timestamp;

if ($diff < 25200) {echo 'the given time is before 7:00am';}
else {echo 'the given time is after 7:00am';} 
?>

[tomalatski]

Thanks for the reply - I will get back to you in a couple of days to let you know how it worked - cheers