Skip to Main Content
Forums

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!

What is wrong with this milliseconds date format?

Aadhya PatelMar 7 2016 — edited Mar 8 2016

Can somebody tell me what is wrong with the following SQL?

CREATE TABLE FR_D_TEST


   (           MILISECS DATE


   );


 


select * from fr_d_test


WHERE milisecs BETWEEN TO_DATE('2015-12-07 23:00:00.000', 'YYYY-MM-DD HH24:MI:SS.FF') AND TO_DATE('2016-03-06 22:59:59.999', 'YYYY-MM-DD HH24:MI:SS.FF');


 


Error starting at line 1 in command:


select * from fr_d_test


WHERE milisecs BETWEEN TO_DATE('2015-12-07 23:00:00.000', 'YYYY-MM-DD HH24:MI:SS.FF') AND TO_DATE('2016-03-06 22:59:59.999', 'YYYY-MM-DD HH24:MI:SS.FF')


Error report:


SQL Error: ORA-01821: date format not recognized


    

  1. 01821. 00000 -  "date format not recognized"
    2. 



*Cause:   


*Action:
This post has been answered by AndrewSayer on Mar 7 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 5 2016
Added on Mar 7 2016
7 comments
20,145 views