迁移dateadd和日期部分从sybase oracle

0

的问题

我试图迁移到这句话从Sybase sql Oracle但我现在不如何实现 dateadddatepart.

select  @v_date = convert(char,convert(char(4),datepart(year, dateadd(month, -13, getdate()))) + "/" + 
         right(( "00" + convert(varchar(2), datepart(month, dateadd(month, -13, getdate())))) , 2) + "/01", 112)

我已经搜查和Oracle使用知道 interval 但我还是不明白如何。

database migration oracle sybase
2021-11-23 14:41:01
1

最好的答案

0

我不是一个Sybase人,但是我正在假定的代码你想开始个月,13个月前。

在这种情况下,其:

SQL> select trunc(add_months(sysdate,-13),'MM') from dual;

TRUNC(ADD
---------
01-OCT-20
2021-11-24 04:33:37

其他语言

此页面有其他语言版本

Русский
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................