:::SELECT sitevisitorID FROM sitevisitor WHERE sitevisitorDate=DATE_FORMAT('2024-04-29 16:29:34','%Y-%m-%d')