Skip to Content
0
Jun 27, 2018 at 04:24 AM

"cannot convert to a timestamp" (send to oracle server)

280 Views

hi everyone.

I want to try to INSERT query from sql anywhere to oracle server.

on oracle server, data type is datetime.

so I write

"INSERT TMP_TABLE(DMT) VALUES (DATETIME('2018-06-27 12:34:56'))"

develop language is vb.net 2017

but returned "cannot convert to a timestamp"

I tried to many method.. but can't find solution.

connection is OLEDB.

already tried to DATE_ORDER='DMY'.

and so on...

if you have any solution, please help me.

thanks