Pull 2 week data

Have data like below

Emplid name  datecreated
1.            Bob.    2018-04-01
2.             Jim.       2017-04-01

I want to pull just  last 2 week data starting today

Who is Participating?
slightwv (䄆 Netminder) Commented:
sysdate-14 is 14 days from right now.
trunc(sysdate)-14 is 14 days from midnight today.

select * from your_table where datecreated>=trunc(sysdate)-14
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.