Do you have a question? Post it now! No Registration Necessary. Now with pictures!
November 1, 2006, 9:20 pm
rate this thread
able to query against this date in a search but would probably use only a
date. IE. timestamp 2006-11-01 13:25:01 and I would want to query for
11-01-2006. Hopefully that makes sense. I don't know really where to begin
with this one. Does anyone have any great tutorial on working with
timestamp? I appreciate any help you may be able to give.
Re: need help with dates
Not sure that you need a big tutorial ;-) What you need to do is just
use a query that is similar to the following:
SELECT * FROM table WHERE my_timestamp > '2006-11-01' AND my_timestamp
this query will return you all records for 2006-11-01.
http://www.alexatnet.com/ - PHP/ZendFramework/Ajax blog