Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

query

2 Posts 2 Posters 0 Views 1 Watching

N Offline
N Offline
neoghy

wrote on last edited by

#1

Hi actually i wanted to write a query which will show all the details from a particular time duration to another duration , Like all details between the year 2006 and 2007 and even if the year is same how to select data based on the months. Please help

skd
U 1 Reply Last reply

0
N neoghy

Hi actually i wanted to write a query which will show all the details from a particular time duration to another duration , Like all details between the year 2006 and 2007 and even if the year is same how to select data based on the months. Please help

skd
U Offline
U Offline
Usharva

wrote on last edited by

#2

Try this select DateCol from TableName where DateCol between '01/01/2007' and '01/01/2008'
1 Reply Last reply

0

Log in to reply