用于从日期中提取年份的 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屋!