Query between two dates

[wwwcatalin]

Hi,

i have a field in my table of  type datetime ( like 6/2/2005 4:41:23 AM ) 

I need a query that gives me all the records with that field between two dates ( let's say 1/1/2006 and 3/3/2006)  ... 
Can anyone help me ?

[Lars_Berg]

select <columnsOfInterest>
  from <tableName>
 where <dateTimeColumn> between '2006-01-01' and '2006-03-03'

The format for specifying date literals varies between DBMS. You should always specify which DBMS you are using.