TO_DATE format SQL

Question

I'm beginner. I have a problem that I can't solved. I would like to add the arguments for DATE. But I have an exception: ORA-01830: date format picture ends before converting entire input string. My code is below.

AND 
TO_DATE(so.org_due_date,'DD-MM-YYYY') >= ('01-11-2021')

Can somebody give tips how can I add this arguments? Thanks every1 for help. I appreciate that.

score 0 · Accepted Answer · answered Nov 24 '21 at 07:46

Assuming that the org_due_date column be text, containing text dates in the format DD-MM-YYYY, the comparison should be:

TO_DATE(so.org_due_date, 'DD-MM-YYYY') >= date '2021-11-01';

While the input to the TO_DATE() function is text in the format DD-MM-YYYY, one valid Oracle date literal takes the format given above.

score 0 · Answer 2 · answered Nov 24 '21 at 07:58

Assuming that so.org_due_date is a DATE datatype, the TO_DATE function should be used on the right side.

AND so.org_due_date >= TO_DATE('01-11-2021', 'DD-MM-YYYY')

Or use a date literal in the YYYY-MM-DD format.

AND so.org_due_date >= DATE'2021-11-01'

TO_DATE format SQL

2 Answers2