Post reply

Date Conversion

  • June 22, 2007 at 9:33 pm

    #153648

    I would like to know how to transform any given date to day 1 of the year in the given date AND the new date must maintain the datetime/smalldatetime data type.

    For example, if a user gives a date of 2006-06-23, I want to convert it to 2006-01-01.

  • June 22, 2007 at 9:38 pm

    #714747

    Substitute your date column or date variable for GETDATE() in the following...

     SELECT DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 22, 2007 at 9:42 pm

    #714748

    You the man Jeff!!!!!!!!!!!!!

  • June 22, 2007 at 9:43 pm

    #714749

    Heh... thanks for the feedback, David.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply