Sql

Search

sql add year to date

//Returns Date time
//Takes where to add (as in year, month, day, etc) to
//Takes how much to add
//Takes a datetime in some different formats
DATEADD(year, 1, '2017/08/25')

Comment

PREVIOUS	NEXT

Code Example
Sql :: UseSqlServer no definition
Sql :: sql server alter table column nullable
Sql :: query to list all tables in sql database
Sql :: start mysql server by terminal in linux
Sql :: update password postgres user
Sql :: reset mysql root password mac
Sql :: liquibase alter column type / length
Sql :: show max_allowed_packet mysql
Sql :: mysql add column if not exists
Sql :: rename column oracle
Sql :: mysql show indexes on table
Sql :: oracle search code in packages
Sql :: alter table delete column
Sql :: find names starting with vowels in sql
Sql :: how to ckeck that email is present in databse in mysqli
Sql :: get current month mysql
Sql :: mariadb alter user host
Sql :: status mysql
Sql :: psql view enum values
Sql :: how to list function in psql
Sql :: grant permission in postgres
Sql :: sql datetime as date
Sql :: oracle list next running jobs
Sql :: oracle failed login attempts
Sql :: postgresql pg_dump
Sql :: sql beginning of previous month
Sql :: sometimes i cant edit sql developer
Sql :: Sql Server join multiple column values and separate with comma
Sql :: oracle activate job
Sql :: oracle db create new schema

Search

SQL

sql add year to date

ADD CONTENT