DateTime | Varinder Sandhu

SQL Server – How Like operator work with datetime

Varinder Sandhu SQL, SQL-General, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Today, my one of the friend shared a very interesting fact about like operator. With the help of this post I am sharing with you all. We need to convert it to character data while comparing with the like operator. Let‘s check with example Like operator with datetime Like Operator

» Read more

DateTime, Like Operator, SQL Server

SQL Server 2012 – New DateTime Functions

Varinder Sandhu SQL, SQL-General, SQL-Server 2012, SQL-Tips and Tricks, Varinder Sandhu

There are seven new datetime functions are introduced in SQL Server 2012 as motioned below DATEFROMPARTS ( year, month, day) DATETIMEFROMPARTS ( year, month, day, hour, minute, seconds, milliseconds ) DATETIME2FROMPARTS ( year, month, day, hour, minute, seconds, fractions, precision ) DATETIMEOFFSETFROMPARTS ( year, month, day, hour, minute, seconds, fractions,

» Read more

DateTime, SQL Server