using date

[pieandpeas]

I'd like to return items where the date column in a database e.g - (12/08/2007 08:16:00) is less than 30 days from the current date

any help would be great

[sourabhmca]

I'd like to return items where the date column in a database e.g - (12/08/2007 08:16:00) is less than 30 days from the current date

any help would be great

hi,

select <<items_column> > from <<tablename>> where convert(char(10 ),date,101) between convert(char(10 ),getdate()-30,101) and convert(char(10 ),getdate(),101 )

[ck9663]

I'd like to return items where the date column in a database e.g - (12/08/2007 08:16:00) is less than 30 days from the current date

any help would be great

try:

select * from mytable where datediff(dd, datefieldonyourtable, getdate()) < 30