Date & Time cutoff

[rcoursey]

I have information I want to display if it is between now and before a time and date. I have the date and time the info will no longer be active in a MySQL datetime field. Time is an issue here also. A particular item might not be displayed after 6:00 pm today for example.

Would I have to convert it to a timestamp to test it with a conditional statement or can I use the datetime as it is stored in mySQL?

[tha_mink]

You can do it all with SQL.

Check it out ....

http://www.mysql.com/doc/en/Date_and_time_functions.html

[rcoursey]

OK,

Let's suppose the selection criteria is based on finding a record with a date that is equal to today and less than or equal to a datetime. The first test would be in the format of YYYYMMDD and the other test would be YYYYMMDD HH:MM:SS. Is this possible to accomplish using a SELECT query and having all criteria evaluated whlle the data extraction from the table is occuring.?

SELECT * FROM table WHILE datetime > now() and datetime <= datetime

Is this the idea? ot is there a better way?

[rcoursey]

I actually ran this code :

SELECT *
FROM table
WHERE (stop >= now( ) AND now() < stop);

I also tried:

SELECT *
FROM table
WHERE stop between now( ) AND stop;

Both of the queries gave the same results. Two records one of the results had a stop datetime from June 4. This is NOT what I was looking for.

Any ideas on how to get the info?

[bad76]

Hi,
you can try to use the date and time function.

You can isolate the day from your field and check with curdate(), and the hours with curtime().

something as this

SELECT *
FROM table
WHERE (hour(stop) >= hour(curtime( )) AND dayofyear(stop)=dayofyear(curdate())