This is a discussion on "Querying Dates" within the Databases section. This forum, and the thread "Querying Dates are both part of the Program Your Website category.
|
|
|
|
|
 |
||
Querying Dates
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
Apr 10th, 2007, 09:59
|
|||
|
|||
|
Querying Dates
Hi there,
I am trying to write an SQL statement that will pull out all records in a database where the date is higher than or equil to the current date. I have this: "SELECT * FROM `events` WHERE `from` >= NOW() ORDER BY `from` ASC LIMIT 1" 'from' is a date field (not datetime). Which seamed to work until today. The script was meant to drop the current event today and replace it with the next in line. Well, it did it yesterday instead. Does anyone have any ideas on how I can get this to work properly? 
|
|
|
|
Apr 13th, 2007, 14:59
|
|||
|
|||
|
Re: Querying Dates
For anybody interested. I reset the server and it is now working perfectly.
|
|
| Tags |
| mysql, now, remove past items, selecting dates |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| question about querying 2 databases in php | sudhakararaog | PHP Forum | 1 | Mar 11th, 2008 19:33 |
| Querying Microsoft SQL server 2005 | alexgeek | Classic ASP | 14 | Sep 30th, 2007 01:28 |
| Form Element has no properties when querying | antonyx | JavaScript Forum | 13 | Aug 25th, 2006 14:06 |
| dates in SQL | spinal007 | Databases | 3 | Nov 10th, 2004 09:32 |
| dates | benbacardi | Classic ASP | 2 | Sep 14th, 2004 16:18 |
