Page 1 of 1

retrieving records

PostPosted: Sat Nov 07, 2009 7:28 pm
by sivanandam
there is a table with date column.. which consist of date from 1st day to the end of month.. my quest is ?is it possible
to retrieve the records between this date..if means plz tell the query

Re: retrieving records

PostPosted: Mon Nov 09, 2009 7:07 pm
by swd
Hi,

I don't really understand what you are asking. If your table has a date column that has values are from the first of the month to the last of the month, then you can select BETWEEN 2 dates values, so

SELECT * FROM TABLE.NAME WHERE DATE_COLUMN BETWEEN '01.10.2009' AND '31.10.2009'

or you can select between any 2 dates you want to. I'm not sure if this is what you mean, so please can you clarify.

Re: retrieving records

PostPosted: Mon Nov 16, 2009 10:21 pm
by sivanandam
thank u .. i had a doubt whether we can use' between' now my doubt cleared.