How to insert date and time in oracle? via c#

Asked

Viewed 519 times

-3

I’m developing a desktop application and everything was working fine until the time I tried to insert the date and time generated by C# into an oracle table. Can someone teach me the query to insert the date in this format:

21/07/2018 12:54:35: (dd/mm/yyyy hh24/mm/ss).

1 answer

0


 INSERT INTO tabela 
(codigo, datahora ) 
VALUES
(1, TO_DATE(nvl('','19/07/2017 19:49:00'),'DD/MM/YYYY HH24:MI:SS'))

Solved :)

Browser other questions tagged

You are not signed in. Login or sign up in order to post.