Time problem in queries

mkarabulut

Hello,
I live a trouble with querying database for records of specific time interval. In ASP, I used to get the specific date information with dateADD func. and easily query the database with something like that ' .. where date < "&date_added_date&"' .
But unfortunately there isn't any function equals to dateadd in php though its great function library(Surprising,isn't it?).
In this site I found out a good tutorial about rebuilding dateadd function for PHP and there was a good stuff about date functions of PHP.
But I am lazy nowadays, is there a shortcut to make this query ? I hope there is something in mysql like
" SELECT * FROM records WHERE timestamp(my_date_field)< $time_stamped_date "

And by the way, the date field in my database table is in Y-m-d format(is it called smalldate,anyway...).

Thanks in advance.

[deleted]

PHP has a load of functions for calculating with dates and times.

However, a function like date_add is quite pointless when used for databases, because databases can do that themselves
Read the manual of your database, for ex; mysql has date_add() and date_sub().

never make PHP do the database's job.

fitzbean

Working with dates in mySQL is a pleasure..

Pull new records in last hour..

SELECT * FROM table_name WHERE timestamp > NOW() - INTERVAL 1 HOUR

Pull records in last week..

SELECT * FROM table_name WHERE timestamp > NOW() - INTERVAL 7 DAY

The timestamp field should be a "TIMESTAMP" type, though I think those functions work with any date type (though I'm not positive).

You can format timestamp dates either in php or at the mySQL level i.e.:

SELECT DATE_FORMAT(NOW(),'%Y/%m/%d')

would return 2002/04/27

Put "date" into the search over at mysql.com, and "Date/Time functions" will be one of the search results. You'll find all the details there.

mkarabulut

Indeed I have recently found out this 'date_add' function from mysql documentation,and saw your message. well, this is really good that mysql includes such functions. But can you give me a clear sample query using this function ?

mkarabulut

Thanks.
That was good enough.