How to select from datetime in sqlite?
Posted
by Sein Kraft
on Stack Overflow
See other posts from Stack Overflow
or by Sein Kraft
Published on 2010-05-13T02:07:38Z
Indexed on
2010/05/13
2:14 UTC
Read the original article
Hit count: 382
Joined is a datetime data type column in the database and dates are saved as '12/05/2010 15:54:32' This my query:
SELECT *
FROM users
WHERE joined BETWEEN '12/05/2010 00:00:00' AND '12/05/2010 59:59:59'
ORDER BY id ASC
But it doesn't work. It returns no rows.
So how i gan get them?
© Stack Overflow or respective owner
