Detail Focused
Tuesday, February 21, 2017
Oracle find records by date diff
Here is the sql
;
INTERVAL default is 2 digit. If you need 3, need do this INTERVAL '300' DAY(3)
http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements003.htm
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment