Table of contents
Documentation SQL

Clean BadgePass Database

Select Date/Time Range

Select * from AccessEvent where sourceDateTime > cast('2021-04-21' as datetime) AND sourceDateTime < cast('2022-01-01' as datetime)

Select Before Date/Time

Select * from AccessEvent where hostReceiptLocalTime < cast('11-17-2015' as datetime)

Delete Date/Time Range

Delete from AccessEvent where sourceDateTime > cast('2021-04-21' as datetime) AND sourceDateTime < cast('2022-01-01' as datetime)

Delete Before Date/Time

Delete from AccessEvent where hostReceiptLocalTime < cast('11-17-2015' as datetime)
previous
Auto-Increment Column
next
Query Access Control Schedules