SQL Server Date Time formatting

Datatime manupulation in SQL server

 

 

SELECT
CONVERT(CHAR(10),LASTUPD_EW_DTTM,121)
FROM PS_D_DEPT

 

Result

2008-06-06

Advertisements