sql date format unrecognized

[Caibing]

I use quickforms Date&Time input, link to SQL, using “to_date(‘date_Time’,‘YYYY-MM-DDTHH:SS:MM’)”, pop up alarm :“ORA-01821, date format unrecognized”

start_date value :2021-10-06T15:27:55

between to_date(’$${Sstart_date}$$’,‘YYYY-MM-DDTHH:MM:SS’)
and to_date(’$${SEnd_date}$$’,‘YYYY-MM-DDTHH:MM:SS’

[mlauber71]

@Caibing

to_date(’$${Sstart_date}$$’,‘YYYY-MM-DDTHH:MM:SS’)

As far as I understand this should be ORACLE Date formats, so it might have to look something like this:

TO_DATE('$${Sstart_date}$$', 'YYYY-MM-DD"T"HH24:MI:SS')

You might have to experiment with the settings as I do not have an ORACLE system present.

Oracle / PLSQL: TO_DATE Function

[Caibing]

Thank you very , it is good solution ,