sql date format unrecognized

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’

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.

https://www.techonthenet.com/oracle/functions/to_date.php

5 Likes

Thank you very , it is good solution ,

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.