MS SQL date time format

[judithSampathwa]

hi there,

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
thanks.....

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.

[plevexier]

if you're using SSRS, you can modify the property of the textbox by right clicking on the cell that contains the date to format, click on the Format tab, and select the "Format Code" button. A new window will show up that will allow you to chose the date format you want.

Check this link for more info:
http://www.simple-talk.com/sql/reporting-services/beginning-sql-server-2005-reporting-services-part-1/

[jreddin]

Hello,
Does the field in the report server have to be a DATETIME field? Could you use a character string that looked like a date field?

For example
SQL statement Will give the following output
Select Convert(Varchar, GETDATE(), 9) -- Jan 17 2011 2:16:12:740PM
Select Convert(Varchar, GETDATE(), 13) -- 17 Jan 2011 14:16:48:657
Select Convert(Varchar, GETDATE(), 109) -- Jan 17 2011 2:17:46:950PM
Select Convert(Varchar, GETDATE(), 113) -- 17 Jan 2011 14:18:04:083

[fawadkhalil]

According to my understanding you dun want time to be displayed with date
you can try this

select convert(varchar(12),getdate())

It will gave you date with format:
Jan 28 2011