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

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

Cannot Call Stored Procedure using Entity Framework

 How to call Stored Procedure using Entity Framework? First you have to Add the SP to Entity Framework Model. But you cannot see the SP name under Complex Types or Function Model under Model Browser. It lies with your SP that using Temp table. If you are using Temp Table in your SP, you must add SET FMTONLY OFF;    On top of the SP, and re-add the SP, the SP will be usable in Entity Framework.
Read more