DATEADD() – Date Related Functions

I am steady in my creation of short articles or tidbits on Transaction SQL date/time functions. Most, if not all, modern day computer systems collect data which contains dates and times. Many times you will want to add or subtract a fixed number of years, months, or etc from a date time variable. Today, I will be exploring the DATEADD() function. This function has 13 different input parameters that can be passed to change the resulting output. To summarize, the function takes a date part, a offset number, and date/time…

DATENAME() – Sub-second Functions

I am unwavering in my creation of short articles or tidbits on Transaction SQL date/time functions. Most, if not all, modern day computer systems collect data which contains dates and times. Many times you will want to convert the data from one data type to another. Today, I will be exploring the DATENAME() function. This function has 15 different input parameters that can be passed to change the resulting output. In short, the function takes a date part and date/time variables as input returns the part that you want a…

DATENAME() – Time Related Functions

I am unrelenting in my creation of short articles or tidbits on Transaction SQL date/time functions. Most, if not all, modern day computer systems collect data which contains dates and times. Many times you will want to convert the data from one data type to another. Today, I will be exploring the DATENAME() function. This function has 15 different input parameters that can be passed to change the resulting output. In short, the function takes a date part and date/time variables as input returns the part that you want a…

DATENAME() – Date Related Functions

I am untiring in my creation of short articles or tidbits on Transaction SQL date/time functions. Most, if not all, modern day computer systems collect data which contains dates and times. Many times you will want to convert the data from one data type to another. Today, I will be exploring the DATENAME() function. This function has 15 different input parameters that can be passed to change the resulting output. In short, the function takes a date part and date/time variables as input returns the part that you want a…

TIMEFROMPARTS() – Date/Time Functions

I am unfaltering in my creation of short articles or tidbits on Transaction SQL date/time functions. In software engineering, the presentation layer, the business logic layer, and the data access layer might be written using different technologies and on different servers. For instance, Web Forms (ASP.NET) might be used in the presentation layer, Web Services (C#.NET) might implement the business application layer, and SQL Server (TSQL) might constitute the data access layer. With this design, the application (presentation tier) might have the end user choose month, day and year from…

DATETIMEOFFSETFROMPARTS() – Date/Time Function

I am serious about writing another short articles or tidbits on Transaction SQL date/time functions. In software engineering, the presentation layer, the business logic layer, and the data access layer might be written using different technologies and on different servers. For instance, Web Forms (ASP.NET) might be used in the presentation layer, Web Services (C#.NET) might implement the business application layer, and SQL Server (TSQL) might constitute the data access layer. With this design, the application (presentation tier) might have the end user choose month, day and year from a…

DATETIME2FROMPARTS() – Date/Time Functions

I am bent on writing another short articles or tidbits on Transaction SQL date/time functions. In software engineering, the presentation layer, the business logic layer, and the data access layer might be written using different technologies and on different servers. For instance, Web Forms (ASP.NET) might be used in the presentation layer, Web Services (C#.NET) might implement the business application layer, and SQL Server (TSQL) might constitute the data access layer. With this design, the application (presentation tier) might have the end user choose month, day and year from a…

DATETIMEFROMPARTS() – Date/Time Function

I am fixed on writing another short articles or tidbits on Transaction SQL date/time functions. In software engineering, the presentation layer, the business logic layer, and the data access layer might be written using different technologies and on different servers. For instance, Web Forms (ASP.NET) might be used in the presentation layer, Web Services (C#.NET) might implement the business application layer, and SQL Server (TSQL) might constitute the data access layer. With this design, the application (presentation tier) might have the end user choose month, day and year from a…

SMALLDATETIMEFROMPARTS() – Date/Time Function

I am steadfast in writing another short articles or tidbits on Transaction SQL date/time functions. In software engineering, the presentation layer, the business logic layer, and the data access layer might be written using different technologies and on different servers. For instance, Web Forms (ASP.NET) might be used in the presentation layer, Web Services (C#.NET) might implement the business application layer, and SQL Server (TSQL) might constitute the data access layer. With this design, the application (presentation tier) might have the end user choose month, day and year from a…

DATEFROMPARTS() – Date/Time Function

I am determined to write another short articles or tidbits on Transaction SQL date/time functions. In software engineering, the presentation layer, the business logic layer, and the data access layer might be written using different technologies and on different servers. For instance, Web Forms (ASP.NET) might be used in the presentation layer, Web Services (C#.NET) might implement the business application layer, and SQL Server (TSQL) might constitute the data access layer. With this design, the application (presentation tier) might have the end user choose month, day and year from a…