Tag: database developer

DATEDIFF() – Time Related Functions

admin

I am constant 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 calculate the difference between two given dates using a particular unit of measure (date part) like hours, minutes, or seconds. Today, I will be exploring the DATEDIFF() function. This function has 12 different input parameters that can be passed to change the resulting output. To summarize, the function takes a date part, a…

DATEDIFF() – Date Related Functions

admin

I am unfluctuating 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 calculate the difference between two given dates using a particular unit of measure (date part) like day, week, month, quarter or year. Today, I will be exploring the DATEDIFF() function. This function has 12 different input parameters, units of measure (date part), that can be passed to change the resulting output. To summarize,…

DATEADD() – Sub-second Functions

admin

I am a pertinacious 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…

DATEADD() – Time Related Functions

admin

I am a eager beaver 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,…

DATEADD() – Date Related Functions

admin

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

admin

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

admin

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

admin

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

admin

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

admin

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…