IBM Mainframe Forum

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

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.

thank u .. i had a doubt whether we can use' between' now my doubt cleared.