locked
Excel date to SQL date RRS feed

  • Question

  • Hi all,

    I have data in EXCEL as

    Excel date         DAYS

    -------------------------------------      

    1/1/2013            90            

    12/31/2012        100

    In SQL i have a table as

    -------------------------------------------------------------------------------------------------

    Excel_Date(varchar),           DAYS(varchar),          SQL_Main_Date(varchar)

    -------------------------------------------------------------------------------------------------

    (All the columns are VARCHAR datatype)

    Now i want to update the values of "SQL_Main_Date" with "Excel date + Days"

    i.e; for 1st row-- 90 days after 1/1/2013 ( 1/1/2013+90 )

    Plz help me

    Thanx

    Tuesday, September 25, 2012 11:34 AM

Answers

All replies