Excel Float Short Form value fixed

 =TEXT(C2,"00%") 

Now upload excel file to sql server. then remove last 3 characters. Use: =TEXT(C2,"00%")

Delete last 3 Characters in SQL

  DECLARE @String NVARCHAR(100)

    SET @String = '12354851'
    SELECT LEFT(@String, NULLIF(LEN(@String)-1,-1))

Get Invalid Date

 

Get Invalid Dates

function isdate().

Ammu with my sisters

 

Git Commands For check in Files. 3 Steps

 $ git add .  (git add . for all files changes/New)

$ git commit -m "Changes" (in Master branch changes)

$ git push (Finally push)

Get Only Firdays in SQL

 SELECT Fridays = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)

FROM (SELECT TOP 366 num = ROW_NUMBER() OVER(ORDER BY a.NAME)-1 FROM dbo.syscolumns a, dbo.syscolumns b) n

WHERE DATENAME(weekday, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)) = 'Friday'

epoch date convert in javascript

 epoch date is generally in seconds and milliseconds.

sample:   /Date(1665424800000)/

javascript code to convert in readable date:  

var lsad = String(LoanSanctionApproveDate);

        var lsadUnixDate = lsad.slice(6, 19);

        var lsadToInt = parseInt(lsadUnixDate);

        var loanSancAprvDate = new Date(lsadToInt).toLocaleDateString('es-CL');