Mathmatical Function in Sql Sever

Mathmatical Function in Sql Sever:- Abs Ceiling Floor Power Rand Square Sqrt Round 1.Abs (numeric_expressions)- Abs stands for absolute and returns, the absolute (positive) number. Syntax- select  ABS(numeric_expression) Ex- ---Abs functions select ABS(011) ---return 011 select ABS(-101)--return 101 not include minus sign select ABS(111.1)---return 111.1 2. Ceiling() & Floor() functions:-Ceiling...

Read More

DateTime GetDate Datepart DateDiff DateTime2 DATEPART DATEADD Function in SqlServer

DATETIME  functions in sql server:- Datetime data types Datetime functions Understand UTC time and time zone offset. Datetime :- UTC Stands for coordinated universal time, based on which , the world regulates clock and time. There are slight differences between GMT and UTC, But for most comman purposes, UTC is synonymous with GMT DATETIME:- Data type Format Range Accuracy Storage size(Bytes) Time hh:mm:ss [.nnnnnnn] 00:00:00:0000000...

Read More