Fetching records based on two dates and with a certain time frame from a table two

[bobbymvs]

Hye any body can suggest me how to transactions betwene two dates from a table with certain time gap


ex: i need from yesterday say around night 10.00 oclck to today night 10.00 clock ...

Pls guide me in this

[rushdishams]

you can use comparisons on date fields in a table like <,>,<=, >= and <>.

as you are working with timestamps, you have to compare them as well.