SQL中当前日期两周后的日期(date after two weeks from current date in SQL)

SQL中当前日期两周后的日期(date after two weeks from current date in SQL)

如何在当前日期两周后提取日期？

例

SELECT blabla FROM table WHERE blabla IN [sysdate + 2 weeks]

How can I do to extract date after two weeks from current date?

Example

SELECT blabla FROM table WHERE blabla IN [sysdate + 2 weeks]

最满意答案

怎么样 ... ？

SELECT blabla FROM table WHERE blabla > SYSDATE AND blabla < SYSDATE +14;

此SYSDATE +x表示从现在起x天。

ps ：对于日期为+14的记录使用...

SELECT blabla FROM table WHERE blabla LIKE SYSDATE +14;

正如Ben在下面指出的那样，使用LIKE存在潜在的风险，因为它取决于nls_date_format参数。 请注意设置适当的格式或查看Gordons方法。 @Ben：谢谢你的说明。

希望这有帮助...干杯！

How about ... ?

SELECT blabla FROM table WHERE blabla > SYSDATE AND blabla < SYSDATE +14;

This SYSDATE +x means x days from now on.

p.s.: for records with date now +14 use ...

SELECT blabla FROM table WHERE blabla LIKE SYSDATE +14;

p.p.s. as Ben pointed out below, there is a potential risk in using LIKE as it depends on the nls_date_format parameter. Take care that an appropriate format is set or have a look at Gordons approach. @Ben: Thanks for the note.

Hope this helps ... Cheers!