I have the below oracle query which is throwing the exception , below is the query

```
SELECT GFT.*, PA.*,P.* FROM GFT_DATA GFT, CONTACT_TOKEN CT, EDUCT_ATTRIBUTE PA,
PERSON P WHERE GFT.PERSON_ID = 122445220 AND GFT.TO_CONTACT_TOKEN_ID = CT.CONTACT_TOKEN_ID 
AND GFT.EDUCT_ATTRIBUTE_ID = PA.EDUCT_ATTRIBUTE_ID AND GFT.PERSON_ID = P.PERSON_ID
AND GFT.CREATED_ON  > CAST ('3-JUN-18 00:00:00' AS DATE) 
AND GFT.CREATED_ON <= CAST ('5-JUN-18 23:59:59' AS DATE);

```

Exception which is coming as 

```
ORA-01830: date format picture ends before converting entire input string
01830. 00000 -  "date format picture ends before converting entire input string"
*Cause:    
*Action:

```

Now please advise me how can i correct this above query so that it brings the data for all the days that is for 3 june ,4 june and
5th june , also i am using cast is it effective or any other better option is there