用于从日期中提取年份的 SQL 查询 [英] SQL query for extracting year from a date

问题描述

我正在尝试创建一个仅从选定日期获取年份的查询.IE.select ASOFDATE from PSASOFATE; 返回 11/15/2012，但我只想要 2012.我怎么能只得到年份?我知道可以使用 YEAR 函数，但我不确定如何使用.

I am trying to create a query that gets only the year from selected dates. I.e. select ASOFDATE from PSASOFDATE; returns 11/15/2012, but I want only 2012. How can I get only the year? I know the YEAR function can be used, but I'm not sure how.

推荐答案

由于后标记'oracle'，前两个查询变得不相关，留下第三个查询用于oracle.

due to post-tag 'oracle', the first two queries become irrelevant, leaving 3rd query for oracle.

对于 MySQL:

SELECT YEAR(ASOFDATE) FROM PASOFDATE

无论如何，如果您的日期是字符串，让我们将其转换为正确的日期格式.并从中选择年份.

Editted: In anycase if your date is a String, let's convert it into a proper date format. And select the year out of it.

SELECT YEAR(STR_TO_DATE(ASOFDATE, '%d-%b-%Y')) FROM PSASOFDATE

既然你正在尝试Toad，你可以检查以下代码:

Since you are trying Toad, can you check the following code:

对于甲骨文:

SELECT EXTRACT (TO_DATE(YEAR, 'MM/DD/YY') FROM ASOFDATE) FROM PSASOFDATE;

参考:

这篇关于用于从日期中提取年份的 SQL 查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！