Hi tomy_hkocg,
Use following code to get only date from db.
SELECT CONVERT(varchar, MyDate, 101) FROM DatesTable
Compute Scalar(DEFINE:([Expr1004]=CONVERT(varchar(30),[TEST].[dbo].[DatesTable].[MyDate],101)))
Table Scan(OBJECT:([TEST].[dbo].[DatesTable]))
SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, MyDate)) FROM DatesTable
Compute Scalar(DEFINE:([Expr1004]=dateadd(day, 0),CONVERT_IMPLICIT(datetime,datediff(day,'1900-01-01 00:00:00.000',CONVERT_IMPLICIT(datetime,[TEST].[dbo].[DatesTable].[MyDate],0)),0))))
and Use this link
http://www.sql-server-helper.com/tips/date-formats.aspx[
^]
to convert date formats at user interface.