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

[Former Member]

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

[JamesZ]

Are you using oracle pl/sql or third party interface? Anyway for oracle, you can check whether following convert works:

TO_TIMESTAMP(TO_CHAR(BEGIN_DATE, 'dd.mm.yyyy hh24:mi:ss')