Hello,

please could you tell me how to use the week function in sql, meaning i want to check the week of a column name is between 2 certain numbers.

thanks

"Hiba Hable" <hiba_hable@hotmail.com> wrote in message
news:95624725-1D4D-4C2A-905C-167AF721EAC8@news.elevatesoft.com...
> Hello,
>
> please could you tell me how to use the week function in sql, meaning i
> want to check the week of a column name is between 2 certain numbers.
>

select *, extract(week from insp_date) from audits
where extract(week from insp_date) between 1 and 10

Robert