SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Datetime string

IQMay 16 2019 — edited May 25 2019

Hi All,

My application front end is passing a datetime in the format '2019-05-16 23:59:00.0'

If I use to_date its not working and I get an error message

"ORA-01830: date format picture ends before converting entire input string

01830. 00000 - "date format picture ends before converting entire input string"

*Cause:

*Action:

Would like to know what should I use in this case ?

Thanks

PavanG

Yes you have the required package and it is of the correct version also

1 person found this helpful

Helios-GunesEROL

Hi;

Yes you need to verify all prereq package for your installation. You could have never package which doc mention and you can hit warning message during installation so you can ignore them.

Please see below notes:
http://download.oracle.com/docs/cd/E11882_01/install.112/e17162/pre_install.htm#BABFDGHJ
Minimum Software Versions and Patches Required to Support Oracle Products on IBM Power Systems [ID 282036.1]
Oracle Database on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2) [ID 169706.1]

Regard
Helios

1 person found this helpful

1 - 2

Added on May 16 2019

7 comments

404 views

SQL & PL/SQL

Datetime string

Comments

Post Details