A Date Field in the database has the following data. The SQL statement is as follows:
- Select age, money, birthday from userinfo
Observe carefully that the date field has two formats, one with time and the other without time. In the project, it is likely that the format is adjusted due to changes in requirements, if we only want to query how the data with time can be processed, we really want to use the length function to determine the length and find that it cannot achieve the goal. No matter the length returned by the content is the same, we think of the following solution, see SQL.
- Select age, money, birthday, substr (to_char (birthday, 'hh24: mi: ss ')
- From userinfo where substr (to_char (birthday, 'hh24: mi: ss'), 1 )! = '00: 00: 00 ';
The result is as follows:
This is just a temporary solution I provided when my colleagues asked me. Someone with better methods can reply to me. Thank you!