today:
1,107
yesterday:
1,462
Total:
1,392,095

LAST DAY SQL

admin 2024.01.19 12:16 Views : 383

 

SELECT  TRUNC (SYSDATE, 'YEAR')   AS first_day

,       ADD_MONTHS ( TRUNC (SYSDATE, 'YEAR')

                   , 12

                   ) - 1          AS last_day

FROM    dual;

No. Subject Author Date Views
129 127.0.0.1 issues admin 2024.09.09 268
128 GP 영수증 FOOTER admin 2024.06.30 409
127 GP 영수증 HEADER admin 2024.06.30 414
» LAST DAY SQL admin 2024.01.19 383
125 Null Display Value admin 2024.01.10 366
124 영수증 2023 file admin 2024.01.04 478
123 Column Data 일괄 추가 admin 2023.11.24 310
122 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 313
121 Reversing Require HTTPS admin 2023.06.04 202
120 ipconfig admin 2023.06.03 181
119 127.0.0.1:8080/apex/ admin 2023.06.03 208
118 CHANGE TABLE NAME admin 2023.05.31 237
117 DATE -> DAY CONVERT SQL admin 2023.05.25 145
116 YEAR EXPRESSIONS admin 2023.05.25 143
115 GRAPH (BAR) SQL SAMPLE admin 2023.05.25 152
114 Monthly SUM admin 2023.05.22 186
113 INNER JOIN admin 2023.05.19 2327
112 LOOP TABLE UPDATE admin 2023.05.19 365
111 Global pages admin 2023.05.09 147
110 ORACLE COLLECTION admin 2023.05.08 151