Home Community Discussion Forums Most Active Software Boards LabWindows/CVI Topic

LabWindows/CVI

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SQL Toolkit DBCreateParamChar and Oracle TIMESTAMP Conversion?

SQL Toolkit DBCreateParamChar and Oracle TIMESTAMP Conversion?

‎05-26-2020 06:09 AM

Hello I'm calling a stored producedure which one of the fields on the server database is DateTime type, but there is no 'DBCreateParam' for timestamp format.

 

So I'm using DBCreateParamChar.

 

* If I use e.g. '20-MAR-2020' without time is working fine but the problem I am not storing the time.

* If I add a time '20-MAR-2020 13:22:00'  I got the Oracle error 'ORA-01830: date format picture ends before converting entire input string'.

 

I need to send both Date and Time.

 

Could somebody give an idea to get this working?

 

Thanks

snaptube.cam/ 9apps
0 Kudos
Message 1 of 1
(1,519 Views)
Reply