Convert TIME to Seconds in MSSQL

 

Just put in the Time, and it will return the Seconds

DECLARE @Time Varchar(10)

SELECT DATEDIFF(second,0,cast(@Time as datetime))


Comments

Post a Comment

Popular posts from this blog

Mvc Razor Load Partial view using javascript

You can just load the Partial view using this code: Load the Partial view to the DIV          $( "#divdetail" ).load( ' @ Url.Action( "_Detail" , "GEMS_BCRpt" ) '  +  "?ID="  + ID );   <script>     $(function() {         $("#btn").click(function() {             var id = 10;             var valoare = 'test';             var url = '/TestingImages/Index2?Id=' + id + '&valoareselectata=' + valoare;             window.location.href = url;         });     }) </script> <input id="btn" type="button" value=“submit"/> function changedet(ID) {             $( "#divdetail" ).load( ' @ Url.Action( "_Detail" , "GEMS_BCRpt" ) ' + "?ID=" + ID );     }
Read more

NPM Cordova byPass Proxy

This is to see the config file npm config edit npm config set proxy http://proxy.company.com:8080 npm config set https-proxy http://proxy.company.com:8080 Set Proxy with username and password npm config set proxy "http://domain%5Cusername:password@servername:port/"           - domain/user_name <--- replace / with %5C Check Cordova version npm --version
Read more