Selecting Records from today

charlie.jones · #1 (**permalink**) 08-23-10, 14:14

What is the best way to select records from only today's date? There is one column in the table that is a timestamp data type. Need something like:
SELECT * FROM ORDERS WHERE TIMEPLACED = CURRENT_DATE;

ARWinner · #2 (**permalink**) 08-23-10, 14:22

Try:

SELECT * FROM ORDERS WHERE TIMEPLACED between timestamp(current date,'00:00:00') and timestamp(current date,'24:00:00')

Andy

charlie.jones · #3 (**permalink**) 08-23-10, 16:34

That worked perfectly. Thanks..

Internet Services

Web Development

Digital Marketing

Consumer Tech