Search
 
SCRIPT & CODE EXAMPLE
 

SQL

date_add mysql

Syntax:
DATE_ADD(date, INTERVAL value addunit)

Example:
SELECT DATE_ADD("2017-11-22", INTERVAL 3 YEAR);

Output:
2020-11-22
Comment

PREVIOUS NEXT
Code Example
Sql :: add days in oracle sql 
Sql :: ssh mysql port forwarding 
Sql :: group concat with separator 
Sql :: sql sample tables with data 
Sql :: How Not To Sort By Average Rating 
Sql :: oracle list service names 
Sql :: nvl2 syntax 
Sql :: tsql replace value in json 
Sql :: psql import backup file for windows 
Sql :: oracle character set 
Sql :: adding a check statement in sql 
Sql :: update date of birth in sql 
Sql :: oracle substring 
Sql :: sql multiline comment 
Sql :: MSSQL SYNTAX PROCEDURE FUNCTION TRIGGER 
Sql :: list foreign data tables postgres psql 
Sql :: sql server reseed identity column 
Sql :: wsl install mysql 
Sql :: show processlist mysql full query 
Sql :: add user mysql 
Sql :: update all rows mysql 
Sql :: Incorrect format parameter 
Sql :: how to pass password mysql command line 
Sql :: create database collation 
Sql :: sql decimal to 2 places 
Sql :: sql server week number 
Sql :: list all the tables in sql 
Sql :: sql check double value 
Sql :: how to fetch first 5 characters in sql 
Sql :: how to see the query of a view in mysql 
ADD CONTENT
Topic
Content
Source link
Name
8+9 =