Convert Datetime to date - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Convert Datetime to date

Author

Topic

dr223
Constraint Violating Yak Guru

444 Posts

Posted - 2010-06-08 : 11:02:49

Hi,

The following select statement wirks fine. However, loaddate is output as datetime instead I require it to have ONLY date.. any help pls


SELECT 
tblDuplicateData.LoadRef AS Ref
    , tblDuplicateData.In_ImpFile AS Imported 
    , tblDuplicateData.LoadDate As LoadDate
  , ISNULL([PatCategory],'No_Category') AS Category
, Count(tblProjectPatients.ProjectPatientID) AS Pats 
FROM       tblDuplicateData 
LEFT JOIN tblProjectPatients ON tblDuplicateData.LoadRef = tblProjectPatients.LoadRef 
GROUP BY tblDuplicateData.LoadRef
, tblDuplicateData.In_ImpFile
,tblDuplicateData.LoadDate  
, tblDuplicateData.ProjectID 
, ISNULL([PatCategory],'No_Category') 
ORDER BY tblDuplicateData.LoadRef DESC;

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-06-08 : 11:08:27

Use proper convert option

SELECT 
tblDuplicateData.LoadRef AS Ref
    , tblDuplicateData.In_ImpFile AS Imported 
    , convert(varchar(10),tblDuplicateData.LoadDate,120) As LoadDate
  , ISNULL([PatCategory],'No_Category') AS Category
, Count(tblProjectPatients.ProjectPatientID) AS Pats 
FROM       tblDuplicateData 
LEFT JOIN tblProjectPatients ON tblDuplicateData.LoadRef = tblProjectPatients.LoadRef 
GROUP BY tblDuplicateData.LoadRef
, tblDuplicateData.In_ImpFile
,tblDuplicateData.LoadDate  
, tblDuplicateData.ProjectID 
, ISNULL([PatCategory],'No_Category') 
ORDER BY tblDuplicateData.LoadRef DESC