Naresh Jois
  • Naresh Jois
  • About
  • Recent articles

    TIL: How to configure Storybook with Vite

    3 months ago

    Excellent read on system design

    a year ago

    Cyberpunk 2077

    a year ago

    Nuget Workflow on Azure DevOps

    2 years ago

    Tags

    • .net
    • 2013
    • 300:Rise Of Empire
    • 64 core processor
    • 80 Core Processor
    • AI
    • ASP.net
    • Add new tag
    • Adobe
    • Aero

Update Date Columns with specific intervals

sql • Nov 7, 2012

There are cases when you want to modify the entire date values and add a specific interval say add and Year, The easiest way to do that is
update [Table] set ColumnName= DATEADD(YEAR,1,ColumnName)

Naresh Jois

Recommended for you

Crashed

Recover Jobs from a crashed SQL Server

11 years ago • 1 min read
identity

Nifty Little script to check identity columns

11 years ago • 1 min read

No results for your search, try something different.

Naresh Jois © 2022   •   Published with Ghost