What if the date is stored as date/time and you want to offer a prompt that allows a user to select a date. But!! The date has to be equal to the date in the database.
select * from Orders where cast(CONVERT(varchar(8), OrderDate, 112) AS datetime) = '2004-08-25'
this is how.
Reporting services has problems showing the data in the data-tab though.. it only works in the preview.
select * from Orders where cast(CONVERT(varchar(8), OrderDate, 112) AS datetime) = '2004-08-25'
this is how.
Reporting services has problems showing the data in the data-tab though.. it only works in the preview.
Geen opmerkingen:
Een reactie posten