This is what I have tried:

```
SELECT *
FROM attendance
WHERE createdAt between ('2019-04-01 11:00:00' - interval '1 hour')

SELECT *
FROM attendance
WHERE createdAt BETWEEN '2019-04-01 11:00:00' AND
                        DATE_ADD('2019-04-01 11:00:00', 'INTERVAL 1 hour')

```

Please provide help, thanks.