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.

Recommended Answers

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

Jump to Post

All 3 Replies

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

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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.