Select fields from table where datefield= ?

[raghu_nv]

I want to read records from a table on a datefield value.
Regardless of database (Access ,SQL Server or Oracle) and local system date format setting , what is the Common syntax for SQL Statement.

1) select fields from table where billdate = ?

2) select fields from table where billdate betwen ? and ?

Thanks is advance.