Sri’s Weblog

Welcome to Sri’s WebLog

Archive for the ‘Other’ Category

SQL Server Date Time formatting

leave a comment »

Datatime manupulation in SQL server

 

 

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

 

Result

2008-06-06

Written by addsrikanth

June 9, 2008 at 8:50 pm

Posted in Other

Follow

Get every new post delivered to your Inbox.