I asked this question before also. i have two date times in a table in the MS SQL server database, when i write the query as below. the Sstart Date and the Due Date is displayed as 12/11/2010 12:00:00 AM
it shows correct in the MS SQL business intelligent Development studio query builder by in the report it displays as 12/11/2010 12:00:00 AM. how can i avoid this
SELECT TTitle as Title,Phase,TopicNo as 'Topic No',Agency,CAST(SDate AS DATE) AS 'Start Date',CAST(DDate AS DATE) AS 'Due Date' FROM Proposal WHERE (Status = 'In Progress')
can i get a help on this thanks.