i need mysql date format using select query.i want 2 select the in between dates for example 1.6.2008 to 6.6.2008 means i want 2 select in b/w 1 to 6 date data