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…

DATEPART() Function – Time Zone Offset

I am decisive to write another 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. Not only is it important to know when a sales order came in, but we should fulfill the request using some type of queue (LIFO). If if was a stack (FIFO) implementation, the first person may never get his order! Today, I will be exploring the DATEPART() function. This function has 15 different input parameters that can be passed to…