Pabitra@Microsoft.Research
Translate
Wednesday, 6 September 2017
sql : check date as null and blank and select query
select (case when t.STATUS_DATE is null then '' when t.STATUS_DATE='' then '' when t.STATUS_DATE<>'' then convert(varchar(50),t.STATUS_DATE,103)end) as 'STATUS_DATE' from Mst_Emp
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment