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

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.

Recommended Answers

All 3 Replies

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.