Query to add years to particular date
select dateadd(year,noofyears to be added,datecolumndate)yearadd from tablename
skip to main |
skip to sidebar
SQLQueriesCollection is blog for all sql queries in SqlServer at one place.SQL,SQL Query,SQL Queries,SQL Query Code,SQL Query Example,SQL Query Syntax,Basic Sql Queries,Query,SQL Examples,SQL Basic Queries,Structured Query Language,sql oracle queries,oracle sql queries,sql queries in oracle,sql-oracle,oracle sql.oracle basics,sql basics,oracle sql examples,sql orqcle examples
Blog Archive
-
▼
2008
(20)
-
▼
March
(8)
- Query to add years to particular date
- Query to add years to particular date
- Query to add months to particular date
- Query to add days to particular date
- Query to get only year from particular date
- Query to get only month from particular date
- Query to get only day from particualar date
- Query to get only date from datetime field
-
▼
March
(8)
No comments:
Post a Comment