How to check date format in Oracle?

Question

Oracle

I need to update only the rows where the value of the TODAY field is written without seconds, adding seconds 00::00:00 there. How to do it?

Answer 1

What is the data type of the TODAY field? DATE or VARCHAR2? If DATE, then "00:00:00" is always present unless the time is explicitly specified. If a string (although I don't understand what's the point of storing the full date in VARCHAR2) and date information in the format DD.MM.RRRR HH24:MI:SS, then something like this:

update table_name set today = today || ' 00:00:00' where length(today) = 10;