Skip to content Skip to sidebar Skip to footer
Showing posts with the label Rounding

Sql Server Round After Division

In a stored procedure I have an expression like select @some_val_in_percents = (@total_val / 100) *… Read more Sql Server Round After Division

Two Questions For Formatting Timestamp And Number Using Postgresql

I am selecting a date column which is in the format 'YYYY-MM-DD'. I want to cast it to a ti… Read more Two Questions For Formatting Timestamp And Number Using Postgresql

Datediff With Minute Does Not Return Expected Value

Say, I have the following SQL Server 2008 table with data: CREATE TABLE tbl (dtIn DATETIME2, dtOut … Read more Datediff With Minute Does Not Return Expected Value

Euclidean Distance

Hacker Rank - Weather Observation Station 19 Given a table STATION that holds data for five fields… Read more Euclidean Distance