ora-01830: the date format mask ends

Question

ora-01830: the date format mask ends

Navigation

#1 by (0 votes)

0

Good I have a problem when launching the following query. I want to bring all the receipts issued in the date range.

SELECT COUNT(FCHA_EMSION) AS TotalMesFebrero
FROM PREDIAL.DOCUMENTOS 
WHERE FCHA_EMSION BETWEEN '01/02/2017' AND '30/02/2017';

Error:

ORA-01830ERROR: The date format chew ends before converting the entire chain.

sql oracle

asked by Danserver 03.05.2018 в 20:53

source

1 answer

How to re-calculate data already registered in MySql when editing or deleting a previous record? How to get the current url in Twig in Symfony

score 0 · Answer 1

The error that is giving you is because you did not add the mask to the query I leave you an example and use TO_DATE

  SELECT COUNT(FCHA_EMSION) AS TotalMesFebrero
    FROM PREDIAL.DOCUMENTOS 
     WHERE FCHA_EMSION BETWEEN TO_DATE('01/02/2017', 'DD/MM/YYYY') 
AND TO_DATE('30/02/2017', 'DD/MM/YYYY');