
May 20th, 2000, 12:46 PM
|
|
Junior Member
|
|
Join Date: May 2000
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
I have a timestamp field in a customers table, which is set to the current date/time when a new customer is registered. I want to run daily reports listing all customers who registered that day, but I can't simply query the db (MySQL) where timestamp = '2000-0-521'. Do I need to check for "where timestamp >= '2000-05-21 00:00:00' and timestamp <= '2000-05-21 23:59:59"? If so, how do I convert a date to a datetime type?
any help is appreciated. thanks.
-- tine
|