且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

尝试在 Oracle SQL 中将时间转换为秒

更新时间: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'.