Concatenating Date and String in excel

Question

enter image description here

In Excel i am using following formula :-

="Select Count(1) Into Count1 From TRB_TPOAR Where tpo_id='" & A2 & "' and eta_id=old_eta_id and date_creation=to_date('" &  B2 & "','dd/mm/yyyy HH24:MI:SS') and UTL1_EDS_ID='DEI037';
    if Count1>0 then
     Update TRB_TPOAR Set Eta_id=new_eta_id Where tpo_id='" & A2 & "' and eta_id=old_eta_id and date_creation=to_date('" & B2 & "','dd/mm/yyyy HH24:MI:SS') and UTL1_EDS_ID='DEI037';
     DBMS_OUTPUT.PUT_LINE('" & A2 & "'  UPDATED'); 
    end if;"

In excel sheet Column B contains datetime information(eg 1/14/2013 12:20:01 PM), But when i apply the formula,it adds some other numeric value.Can anyone help me,what are the changes to make in above formula?

you are using that Excel formula to build a SQL statement, right ? — iDevlop, Mar 21 '13 at 10:12
yes actually i have to insert 1000 records in table and only date time is changing in each record — F11, Mar 21 '13 at 10:14

score 2 · Accepted Answer · answered Mar 21 '13 at 10:19

2

In your case, Excel returns the serila number of the date in referenced cell. To make sure it returns a string dispaying the date in the format you want, use =TEXT(cell, FormatString).
E.g.: TEXT(C2, "dd/mmm/yy")
Bonne chance

answered Mar 21 '13 at 10:19

iDevlop

24,841
11
90
149

Concatenating Date and String in excel

1 Answers1