SQL database with temporal data Is it possible to do this in a SQL database  

 SELECT * FROM Employee
    WHERE BirthDate BETWEEN DATE 1970-01-01 AND DATE 1970-01-01


The result that was said to from this query is all the employees that are born on 
1970-01-01.
This query has been taken from the following book
Sorry if this question is lacking.
Some variety of this, depending on RDBMS. SQL Server and MySQL accept date literals like this:

SELECT * FROM Employee
    WHERE BirthDate BETWEEN '1970-01-01' AND '1970-01-01'

SELECT * FROM Employee
    WHERE BirthDate BETWEEN '19700101' AND '19700101'