;

Tags: SQL functions Articles


How to Add and Subtract Dates from DateTime in MySQL

Tutorialsrack 24/05/2020 SQL MySQL

In this article, you will learn how to add or subtract years, months, weeks, days, hours, minutes, seconds, microseconds to a DateTime in MySQL. DateTime manipulation is the most common scenario is when we fetching data from the database or storing data in a database. Here, we used the MySQL built-in DateTime functions: ADDDATE(), DATE_ADD(), DATE_SUB(), and add and subtract dates without using any built-in function. 

Read More..

How to Add and Subtract Dates from DateTime Using DATEADD() Function in SQL Server

Tutorialsrack 23/05/2020 SQL SQL Server

In this article, you will learn how to add and subtract years, months, weeks, days, hours, minutes, seconds, milliseconds, microseconds, nanoseconds from DateTime in the SQL server. DateTime manipulation is the most common scenario is when we fetching data from the database or storing data in a database. Here, in this article, we will use the SQL server built-in DATEADD() function to add or subtract the days from the specific date.

Read More..

How to Reseed an Identity Column value in SQL Server

Tutorialsrack 09/04/2020 SQL SQL Server

In this article, we will learn how to RESEED an IDENTITY column value in SQL Server. SQL Server IDENTITY column generates sequential values for new records inserted in the table using a SEED value. This feature is very useful when you want to reset the identity column. The DBCC CHECKIDENT management command is used to reset the identity counter. 

Read More..
Recent Posts
Tags