EXTRACT 子句
⟩
⟩
⟩
⟩
⟩ Extract clauses

EXTRACT 子句

EXTRACT
 子句从 DateTime 类型列提取日期/时间分量。

示例

SELECT EXTRACT(DAY FROM Time) AS "Day" FROM ...
SELECT EXTRACT(YEAR FROM Time) AS "Year" FROM ...
SELECT EXTRACT(MONTH FROM Time) AS "Month" FROM ...
SELECT EXTRACT(HOUR FROM Time) AS "Hour" FROM ...
SELECT EXTRACT(MINUTE FROM Time) AS "Minute" FROM ...
SELECT EXTRACT(SECOND FROM Time) AS "Second" FROM ...
提供反馈
对本文档有问题或反馈吗？ 请在这里提交您的反馈 。
Normal