更新时间:2023-01-22 12:02:21
您从 MySQL 文档中引用 TIME_TO_SEC
函数,尽管问题用 oracle
标签标记.根据您的需要,使用 extract(second ...)
或 google oracle extract epoch equivalent
.
You refer TIME_TO_SEC
function from MySQL documentation though question is marked with oracle
tag. Use extract(second ...)
or google oracle extract epoch equivalent
, depending on what you want.
还有表达式 EXTRACT(MONTH FROM uti.Date_) = '2020-01-21'
和 EXTRACT(YEAR...
看起来很可疑,返回的值肯定是不是 'YYYY-MM-DD'
形式.
Also the expressions EXTRACT(MONTH FROM uti.Date_) = '2020-01-21'
and EXTRACT(YEAR...
look suspicious, returned values definitely are not of form 'YYYY-MM-DD'
.