I have a webpage that generates a recordset from a SQL database. This database has a datetime field. I have not worked a lot on SQL, but have on MSAccess. In MSAccess it is simple to use a datetime field and use the BETWEEN criteria to get the records that fall between the two dates specified in the BETWEEN clause. However in SQL, it is not letting me select between the two dates. I have used various formats, but none are working. This is what I have written that does not work:
Difference between TIMESTAMPS in Teradata. Forget Code; Teradata; Difference between TIMESTAMPS The difference between two TIMESTAMP types is an Interval type. Consider a table like this: CREATE TABLE customer (phoneno CHARACTER(10),starttime TIMESTAMP(0),endtime TIMESTAMP(0)); The difference can be calculated with Interval unit DAY TO. SQL time difference between two dates result in hh:mm:ss. Ask Question 25. How to return only the Date from a SQL Server DateTime datatype. What is the difference between varchar and nvarchar? Count work days between two dates. Difference between JOIN and INNER JOIN.
![Time Time](http://i.imgur.com/I82aZWk.png)
1. SELECT login,datetime FROM log where ( (datetime between date()-1and date()) ) order by datetime DESC;
2. SELECT login,datetime FROM log where ( (datetime between 2004-12-01and 2004-12-09) ) order by datetime DESC;
3. SELECT login,datetime FROM log where ( (datetime between #2004-12-01# and #2004-12-09#) ) order by datetime DESC;
![Sql timestamp difference Sql timestamp difference](https://i.stack.imgur.com/AdAqb.png)
4. SELECT login,datetime FROM log where ( (datetime between 2004-12-0100:00 and 2004-12-09 00:00) ) order by datetime DESC;
Please help.