date time stamp converting to number when used in formula

[ambuj33]

Hello,

I am in a situation where I am making a sql query by using the columns in excel, out of which 1 column contains date time as 2017-06-13 13:18:18 PM and whenever I used this column in formula it reflects as 42899.554375.

="INSERT INTO ORDERS("&A1&","&B1&","&C1&","&D1&","&E1&") VALUES ("&A2&","&B2&",'"&C2&"','"&D2&"','"&E2&"')"

This is the formula I am making where B2 contains date.

Please assist.

TIA
Ambuj S
[TABLE="width: 159"]
<tbody>[TR]
[TD="class: xl65, width: 159, align: right"]

[/TD]
[/TR]
</tbody>[/TABLE]

 

[footoo]

Try this :

="INSERT INTO ORDERS("&A1&","&B1&","&C1&","&D1&","&E1&") VALUES ("&A2&","&TEXT(B2,"yyyy-mm-dd hh:mm:ss AM/PM")&",'"&C2&"','"&D2&"','"&E2&"')"