Help with a date function

[tony_l]

I am trying to allow a user to add an item to either TODAY, YESTERDAY or TOMMORROW's journal. This is something I think would be pretty much straight forward, but after three hours, I am frustrated.

I found the following function -

date_create(), which allows you to do something sinple - like ADD or TAKE AWAY a day from the given date.

Problem is, it requires a datetime object.

how do I get a datetime object? I have tried using a timestamp, but as I feared, it is not a datetime object. I have looked at the documentation over and over, and I am at a loss.

How can I add or subtract a day from the current date? (without adding or subtracting seconds from a timestamp?

I am in the design phase right now for the database, so it can be changed if needed - any suggestions?

-Thanks in advance!

[dalecosp]

Well, I'm not clear on the question, but, by reputation, I'm kinda dense.

In PHP, generally I use [man]date/man and create some construction with, for example, [man]strtotime/man, something like:

<?php

echo (date('r',strtotime("yesterday")));

?>

But, it sounds like you may be asking for something a little more database oriented. I play with MySQL some, and just found this:

mysql> select current_date;
+--------------+
| current_date |
+--------------+
| 2006-12-23   |
+--------------+
1 row in set (0.05 sec)

mysql> select current_date+1 day;
+----------+
| day      |
+----------+
| 20061224 |
+----------+
1 row in set (0.04 sec)

mysql> select current_date-1 day;
+----------+
| day      |
+----------+
| 20061222 |
+----------+
1 row in set (0.00 sec)

Either of those worth anything to ya?

Merry Christmas (or whatever holiday, if any, is up for you)!

[big_nerd]

Try this, I can expand on it if you need.

$timestamp = time();
$date_time_array = getdate($timestamp);

$hours = $date_time_array['hours'];
$minutes = $date_time_array['minutes'];
$seconds = $date_time_array['seconds'];
$month = $date_time_array['mon'];
$day = $date_time_array['mday'];
$year = $date_time_array['year'];
$date_time_array = getdate($timestamp);
$hours = $date_time_array['hours'];
$minutes = $date_time_array['minutes'];
$seconds = $date_time_array['seconds'];
$month = $date_time_array['mon'];
$day = $date_time_array['mday'];
$year = $date_time_array['year'];

$yesterday = strftime('%m/%d/%Y',mktime("0","0","0",$month,$day - 1,$year));

echo "$yesterday";

This will also allow you to expand quite a bit.

Let me know if this helps...