today:
108
yesterday:
179
Total:
1,001,204

LAST DAY SQL

admin 2024.01.19 12:16 Views : 114 

 

SELECT  TRUNC (SYSDATE, 'YEAR')   AS first_day

,       ADD_MONTHS ( TRUNC (SYSDATE, 'YEAR')

                   , 12

                   ) - 1          AS last_day

FROM    dual;

I want to
List
No. Subject Author Date Views
106 Apex Interactive Report: The difference between CIR and RIR admin 2018.01.26 81
105 STARTUP admin 2022.09.01 83
104 127.0.0.1:8080/apex/ admin 2023.06.03 83
103 Reversing Require HTTPS admin 2023.06.04 84
102 Link- AbbaBeauty admin 2018.02.13 85
101 EMPLOYEE_LEVEL_ID admin 2016.05.03 88
100 Material requirements planning (MRP) admin 2018.02.14 88
99 image (products) admin 2017.11.24 92
98 SQL Basics - Lesson 1 - Introduction admin 2017.06.17 97
97 TEST admin 2023.03.27 97
96 SQL DEVELOPER file admin 2022.03.17 106
95 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 108
94 QR-CODE admin 2017.11.30 111
93 Null Display Value admin 2024.01.10 111
» LAST DAY SQL admin 2024.01.19 114
91 Display Value, Return Value admin 2016.05.10 115
90 Interactive Report admin 2016.05.07 116
89 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 120
88 Oracle SQL Developer: Online Migration 3.1 admin 2018.04.25 120
87 test admin 2016.05.11 121
Write Tag