我如何从Oracle中的日期选择年份 [英] How can i select year from a date in oracle

问题描述

我想在oracle.s中找到两个日期之间的差异.我尝试了这段代码

i want to find the difference between two dates in oracle.i tried this code

select to_date('1-dec-2001')-
           to_date('26-apr-2001') 
    from dual

但它显示以天为单位的日期差异..但是我希望以年份为单位，因此该怎么办?

but it showing date difference in days..but i want the difference as year so what should i do?

推荐答案

尝试以下方法:
http://www.orafaq.com/wiki/SQL_FAQ#How_does_one_get_the_time_difference_between_two_date a <3F "http://www.orafaq.com/wiki/SQL_FAQ#How_does_one_get_the_time_difference_between_two_date_columns.3F" target ="_ blank" title ="New Window"> ^ ]

Try This:
http://www.orafaq.com/wiki/SQL_FAQ#How_does_one_get_the_time_difference_between_two_date_columns.3F[^]

尝试一下

select to_date (date_field,'YYYY') - to_date(date_field,'YYYY') from dual

或者您可以转换查询

or you can convert your query

select  round((to_date('1-dec-2001') - to_date('26-apr-2001') )/365) from dual

这篇关于我如何从Oracle中的日期选择年份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！