changing julian dates in sql 2008 via transaction

Posted on 2011-05-11
Last Modified: 2012-05-11
I have the following dates in  table showing the 16 of the each month. I need to make this the 28th of each month. There are over 50 of them to change and I don;t wish to change one by one.

eg 734304 needs to change to 734316

please see file attached

Question by:Amanda Walshaw
    LVL 41

    Accepted Solution

    why not something like

    update yourtable
    set yourdatecolumn = yourdatecolumn + 12
    LVL 41

    Expert Comment

    or if the table contains other dates including the one showing the 16 of the month

    update yourtable
    set yourdatecolumn = yourdatecolumn + 12
    where day(dateadd(d, yourdatecolumn, '1899-12-31')) = 16

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now