SQL Server Performance

How to add date and time

Discussion in 'SQL Server 2005 General Developer Questions' started by mpolaiah, Sep 28, 2010.

  1. mpolaiah New Member

    Hi alll,

    i am using sql server 2005,
    How to add date and time
    for exampleeeeee

    my date file is 2010-09-29 11:53:00
    and add these file 01:00:00
    these 2 filed added final i want 2010-09-29 12:53:00

    please help mee

    regards
    pols
    mpolaiah, Sep 28, 2010
    #2

  2. FrankKalis Moderator

    Not sure what you mean by "file", but try SELECT DATEADD(HOUR, 1, '2010-09-29 11:53:00')
    FrankKalis, Sep 28, 2010
    #3

Share This Page