today:
1,350
yesterday:
1,582
Total:
1,361,057

LAST DAY SQL

admin 2024.01.19 12:16 Views : 362

 

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 248
128 GP 영수증 FOOTER admin 2024.06.30 389
127 GP 영수증 HEADER admin 2024.06.30 394
» LAST DAY SQL admin 2024.01.19 362
125 Null Display Value admin 2024.01.10 346
124 영수증 2023 file admin 2024.01.04 464
123 Column Data 일괄 추가 admin 2023.11.24 298
122 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 301
121 Reversing Require HTTPS admin 2023.06.04 189
120 ipconfig admin 2023.06.03 169
119 127.0.0.1:8080/apex/ admin 2023.06.03 195
118 CHANGE TABLE NAME admin 2023.05.31 218
117 DATE -> DAY CONVERT SQL admin 2023.05.25 130
116 YEAR EXPRESSIONS admin 2023.05.25 131
115 GRAPH (BAR) SQL SAMPLE admin 2023.05.25 140
114 Monthly SUM admin 2023.05.22 172
113 INNER JOIN admin 2023.05.19 2315
112 LOOP TABLE UPDATE admin 2023.05.19 351
111 Global pages admin 2023.05.09 128
110 ORACLE COLLECTION admin 2023.05.08 139