Wednesday, 6 May 2020

Convert Date in Numeric Format(Remove Separation) In SQL SERVER Query

Try this Query:

SELECT CONVERT(VARCHAR(10),CAST('2019-12-15 00:00:00.000' AS DATE),112) AS date1

Results:- 
        date1
    20191215
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

redirect to new page from jquery

  function foo(id) { var url = ' @Url . Action ( "Details" , "Branch" , new { id = "__id__" })'...