How to get week start date and end date in oracle
Related FAQs
- How to check Oracle Version
- How to get year start date and end date in oracle
- how to get month start date and end date in oracle
- How to get number of days in a given month using oracle
- how to find duplicate records in oracle
- How to get week start date and end date in oracle
- EXPLAIN ROLLUP
- WHAT IS A HISTOGRAM? HOW TO GENERATE STATISTICS?
- WHAT IS QUERY OPTIMIZER? WHAT ARE DIFFERENT TYPES OF OPTIMIZERS SUPPORTED BY ORACLE?
- WHAT ARE DIFFERENT STORAGE OPTIONS SUPPORTED BY ORACLE?
We can get it using to_char
Sun, 11/30/2008 - 05:06 — adminWe can get it using to_char function in oracle
eg: To get current day
select to_char(sysdate) today from dual
eg: to get start day of week
select to_char(sysdate+ (1-to_char(sysdate,'D'))) startdayofweek from dual
eg: to get end day of the week
select to_char(sysdate+ (7-to_char(sysdate,'D'))) endofweek
from dual
eg: to get start and end date of week
select to_char(sysdate+ (1-to_char(sysdate,'D'))) startdayofweek, to_char(sysdate+ (7-to_char(sysdate,'D'))) endofweek from dual