1. Open the oracle database and create a new table. Because the date format is set, the date time and time time fields are both date types, as shown in the following figure:

2. If it is a simple query table, is it displayed as planned or in date format, as shown in the following figure:

3. Setting the date format of the query date display results can be achieved by using the oracle database function to_char, and the results are all strings, as shown in the following figure:

4. In the query editor, enter the following code:

5. After successful input, the operation of modifying the date field value is completed.