TIMEFROMPARTS function – SQL Server Denali

We are going to discuss another new function that’s going to get released with SQL Server Denali. This function is related to date time category. This is similar to the early function which we saw. Time returns a fully initialized time value. If the arguments are invalid then an error is raised, if you have… Continue reading TIMEFROMPARTS function – SQL Server Denali

SMALLDATETIMEFROMPARTS function in SQL Server Denali

Today I’m going to give you a short demo on the new date time function in SQL Server Denali. It’s SMALLDATETIMEFROMPARTS function, are you able to get the things from naming convention. Yep! you are right, this function will return small datetime value with the parts of data being supplied to the function. I hope… Continue reading SMALLDATETIMEFROMPARTS function in SQL Server Denali

Finding END of Month in SQL Server Denali Using EOMONTH function

Today we are going to see a new datetime function that’s introduced with SQL Server Denali. This function is expected by many of the developers, this function will let you know the last date of a month. It’s EOMONTH(), you can pass the date as input , it will give you the end date of… Continue reading Finding END of Month in SQL Server Denali Using EOMONTH function

Formatting Data in SQL Server Denali using FORMAT function

Today we are going to see another new function introduced in SQL Server Denali. It’s nothing but the FORMAT function.This will be very useful feature to format any data in SQL Server. In previous versions we will be using CONVERT function to do some styling in date time etc. However in Denali for sure this… Continue reading Formatting Data in SQL Server Denali using FORMAT function