728x90
๋ฐ˜์‘ํ˜•

์ „์ฒด ๊ธ€ 1364

[js] moment.js ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ duration() ํ•จ์ˆ˜

var startTime = moment('2024-08-09T08:00:00');var endTime = moment('2024-08-10T10:30:45');var duration = moment.duration(endTime.diff(startTime));var days = Math.floor(duration.asDays());var hours = duration.hours();var minutes = duration.minutes();var seconds = duration.seconds();console.log(days + "์ผ " + hours + "์‹œ๊ฐ„ " + minutes + "๋ถ„ " + seconds + "์ดˆ");// ์ถœ๋ ฅ: 1์ผ 2์‹œ๊ฐ„ 30๋ถ„ 45์ดˆ

Front/JS & jQuery 2024.08.13

[js] moment.js diff() ํ•จ์ˆ˜

moment.js ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ์—์„œ๋Š” ๋‘ ๋‚ ์งœ ๋˜๋Š” ์‹œ๊ฐ„ ๊ฐ„์˜ ์ฐจ์ด๋ฅผ ๊ตฌํ•  ๋•Œ diff() ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค. ์ด ํ•จ์ˆ˜๋Š” ๋‘ ์‹œ๊ฐ„ ๊ฐ„์˜ ์ฐจ์ด๋ฅผ ์ง€์ •๋œ ๋‹จ์œ„(์˜ˆ: milliseconds, seconds, minutes, hours, days, etc.)๋กœ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. moment(date1).diff(moment(date2), unit, true); date1: ๋น„๊ตํ•  ์ฒซ ๋ฒˆ์งธ ๋‚ ์งœ/์‹œ๊ฐ„ (moment ๊ฐ์ฒด ๋˜๋Š” ๋‚ ์งœ ๋ฌธ์ž์—ด).date2: ๋น„๊ตํ•  ๋‘ ๋ฒˆ์งธ ๋‚ ์งœ/์‹œ๊ฐ„ (moment ๊ฐ์ฒด ๋˜๋Š” ๋‚ ์งœ ๋ฌธ์ž์—ด).unit: ์ฐจ์ด๋ฅผ ๊ตฌํ•  ๋‹จ์œ„ (์˜ˆ: 'seconds', 'minutes', 'hours', 'days', 'months', 'years' ๋“ฑ). ์ด ๋งค๊ฐœ๋ณ€์ˆ˜๋Š” ์„ ํƒ ์‚ฌํ•ญ์ด๋ฉฐ, ๊ธฐ๋ณธ๊ฐ’์€ 'milliseconds..

Front/JS & jQuery 2024.08.12

[Error][Oracle] ORA-01481: ์ˆซ์ž ํ˜•์‹ ๋ชจ๋ธ์ด ๋ถ€์ ํ•ฉํ•ฉ๋‹ˆ๋‹ค

NVL2('20240808095823', TO_CHAR('20240808095823', 'YYYY-MM-DD HH24:MI:SS'), NULL) ORA-01481: ์ˆซ์ž ํ˜•์‹ ๋ชจ๋ธ์ด ๋ถ€์ ํ•ฉํ•ฉ๋‹ˆ๋‹ค. ์ด ์ฟผ๋ฆฌ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์ด ๋™์ž‘ํ•ฉ๋‹ˆ๋‹ค:'20240808095823'์ด Null์ด ์•„๋‹Œ ๊ฒฝ์šฐ, TO_CHAR('20240808095823', 'YYYY-MM-DD HH24:MI:SS')๋ฅผ ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค.'20240808095823'์ด Null์ธ ๊ฒฝ์šฐ, NULL์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.์ด ์˜ˆ์ œ์—์„œ ๋ฌธ์ œ๊ฐ€ ๋˜๋Š” ๋ถ€๋ถ„์€ TO_CHAR ํ•จ์ˆ˜๊ฐ€ ๋ฌธ์ž์—ด์„ ๋ฐ”๋กœ ๋ณ€ํ™˜ํ•˜๋ ค ํ•œ๋‹ค๋Š” ์ ์ž…๋‹ˆ๋‹ค. ์˜ค๋ผํด์—์„œ ๋‚ ์งœ ํ˜•์‹์˜ ๋ฌธ์ž์—ด์„ ๋ณ€ํ™˜ํ•˜๋ ค๋ฉด ๋จผ์ € ๋ฌธ์ž์—ด์„ TO_DATE ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋‚ ์งœ๋กœ ๋ณ€ํ™˜ํ•œ ํ›„ TO_CHAR๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์›ํ•˜๋Š” ํ˜•์‹์œผ๋กœ ๋ณ€ํ™˜ํ•ด์•ผ ..

Error 2024.08.11

[MySQL] Oracle์˜ NVL, NVL2๋ฅผ MySQL์—์„œ ๊ตฌํ˜„ํ•˜๊ธฐ

MySQL์—์„œ๋Š” NVL์™€ NVL2์™€ ์œ ์‚ฌํ•œ ๊ธฐ๋Šฅ์„ ํ•˜๋Š” ํ•จ์ˆ˜๋กœ IFNULL๊ณผ COALESCE, ๊ทธ๋ฆฌ๊ณ  IF ํ•จ์ˆ˜๊ฐ€ ์žˆ์Šต๋‹ˆ๋‹ค.๊ฐ ํ•จ์ˆ˜์˜ ์‚ฌ์šฉ๋ฒ•๊ณผ ๊ธฐ๋Šฅ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค. IFNULLIFNULL ํ•จ์ˆ˜๋Š” ์˜ค๋ผํด์˜ NVL๊ณผ ์œ ์‚ฌํ•˜๊ฒŒ ์ฒซ ๋ฒˆ์งธ ์ธ์ˆ˜๊ฐ€ Null์ธ ๊ฒฝ์šฐ ๋‘ ๋ฒˆ์งธ ์ธ์ˆ˜๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.IFNULL(expr1, expr2)SELECT IFNULL(commission_pct, 0) AS commission FROM employees;์ด ์˜ˆ์ œ์—์„œ๋Š” commission_pct๊ฐ€ Null์ด๋ฉด 0์„ ๋ฐ˜ํ™˜ํ•˜๊ณ , Null์ด ์•„๋‹ˆ๋ฉด commission_pct ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. COALESCECOALESCE ํ•จ์ˆ˜๋Š” ๋‹ค์ˆ˜์˜ ์ธ์ˆ˜๋ฅผ ๋ฐ›์•„ ์ฒซ ๋ฒˆ์งธ๋กœ Null์ด ์•„๋‹Œ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.์˜ค๋ผํด์˜ NVL๊ณผ ๋น„์Šทํ•˜์ง€๋งŒ, ๋” ๋งŽ์€ ์ธ์ˆ˜๋ฅผ ..

DB 2024.08.10

[Oracle] NVL/ NVL2

์˜ค๋ผํด์˜ NVL์™€ NVL2 ํ•จ์ˆ˜๋Š” ๋‘˜ ๋‹ค Null ๊ฐ’์„ ์ฒ˜๋ฆฌํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค.ํ•˜์ง€๋งŒ ๊ทธ ๊ธฐ๋Šฅ๊ณผ ์‚ฌ์šฉ๋ฒ•์—๋Š” ์ฐจ์ด๊ฐ€ ์žˆ์Šต๋‹ˆ๋‹ค. NVLNVL ํ•จ์ˆ˜๋Š” ์ฒซ ๋ฒˆ์งธ ์ธ์ˆ˜๊ฐ€ Null์ธ ๊ฒฝ์šฐ ๋‘ ๋ฒˆ์งธ ์ธ์ˆ˜๋กœ ๋Œ€์ฒดํ•ฉ๋‹ˆ๋‹ค.์ฒซ ๋ฒˆ์งธ ์ธ์ˆ˜๊ฐ€ Null์ด ์•„๋‹ˆ๋ฉด ์ฒซ ๋ฒˆ์งธ ์ธ์ˆ˜๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.NVL(expr1, expr2)SELECT NVL(commission_pct, 0) AS commission FROM employees;์ด ์˜ˆ์ œ์—์„œ๋Š” commission_pct๊ฐ€ Null์ด๋ฉด 0์„ ๋ฐ˜ํ™˜ํ•˜๊ณ , Null์ด ์•„๋‹ˆ๋ฉด commission_pct ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. NVL2NVL2 ํ•จ์ˆ˜๋Š” ์ฒซ ๋ฒˆ์งธ ์ธ์ˆ˜๊ฐ€ Null์ด ์•„๋‹Œ ๊ฒฝ์šฐ ๋‘ ๋ฒˆ์งธ ์ธ์ˆ˜๋ฅผ ๋ฐ˜ํ™˜ํ•˜๊ณ ,์ฒซ ๋ฒˆ์งธ ์ธ์ˆ˜๊ฐ€ Null์ธ ๊ฒฝ์šฐ ์„ธ ๋ฒˆ์งธ ์ธ์ˆ˜๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.NVL2(expr1, expr2,..

DB 2024.08.09

[SQLD] Entity, Instance, Attribute

์—”ํ‹ฐํ‹ฐ(Entity)์—”ํ‹ฐํ‹ฐ๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—์„œ ๊ด€๋ฆฌํ•ด์•ผ ํ•˜๋Š” ์ค‘์š”ํ•œ ์ •๋ณด์˜ ๋‹จ์œ„ ๋˜๋Š” ๊ฐœ์ฒด๋ฅผ ๋‚˜ํƒ€๋ƒ…๋‹ˆ๋‹ค. ์—”ํ‹ฐํ‹ฐ๋Š” ์ฃผ๋กœ ํ˜„์‹ค ์„ธ๊ณ„์˜ ๋Œ€์ƒ(์‚ฌ๋ฌผ, ์‚ฌ๋žŒ, ๊ฐœ๋… ๋“ฑ)์„ ๋ชจ๋ธ๋งํ•˜๋ฉฐ, ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋‚ด์—์„œ ํ…Œ์ด๋ธ”๋กœ ๊ตฌํ˜„๋ฉ๋‹ˆ๋‹ค.์˜ˆ๋ฅผ ๋“ค์–ด, ์‚ฌ์šฉ์ž(User), ์ œํ’ˆ(Product), ์ฃผ๋ฌธ(Order) ๋“ฑ์ด ์—”ํ‹ฐํ‹ฐ๊ฐ€ ๋  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์ด ์—”ํ‹ฐํ‹ฐ๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค๊ณ„ ์‹œ ์ค‘์š”ํ•œ ์š”์†Œ๋กœ, ๊ฐ ์—”ํ‹ฐํ‹ฐ๋Š” ๊ณ ์œ ํ•œ ์†์„ฑ(Attribute)์„ ๊ฐ€์ง€๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค.์ธ์Šคํ„ด์Šค(Instance)์ธ์Šคํ„ด์Šค๋Š” ํŠน์ • ์—”ํ‹ฐํ‹ฐ์— ๋Œ€ํ•œ ๊ตฌ์ฒด์ ์ธ ๋ฐ์ดํ„ฐ์˜ ์˜ˆ๋ฅผ ๋งํ•ฉ๋‹ˆ๋‹ค. ์ฆ‰, ์—”ํ‹ฐํ‹ฐ๋Š” ์ผ๋ฐ˜์ ์ธ ๊ฐœ๋…์„ ๋‚˜ํƒ€๋‚ด๊ณ , ์ธ์Šคํ„ด์Šค๋Š” ๊ทธ ๊ฐœ๋…์˜ ํŠน์ •ํ•œ ์‚ฌ๋ก€๋ฅผ ๋‚˜ํƒ€๋ƒ…๋‹ˆ๋‹ค.์˜ˆ๋ฅผ ๋“ค์–ด, ์‚ฌ์šฉ์ž(User) ์—”ํ‹ฐํ‹ฐ๊ฐ€ ์žˆ๋‹ค๊ณ  ๊ฐ€์ •ํ•˜๋ฉด, ์‚ฌ์šฉ์ž ์—”ํ‹ฐํ‹ฐ์˜ ํ•œ ์ธ์Šคํ„ด์Šค๋Š” 'ํ™๊ธธ๋™', '..

DB 2024.08.08

[MySQL][Oracle] Boolean ๋ฐ์ดํ„ฐ ํƒ€์ž…์˜ ์ฐจ์ด์ 

MySQL์—์„œ๋Š” Boolean ํƒ€์ž…์„ ์ง์ ‘ ์ง€์›ํ•˜์ง€ ์•Š์œผ๋ฉฐ,๋Œ€์‹  TINYINT(1)์„ ์‚ฌ์šฉํ•ด Boolean์ฒ˜๋Ÿผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.๋”ฐ๋ผ์„œ TRUE๋Š” 1, `FALSE๋Š” 0์œผ๋กœ ํ‘œํ˜„๋ฉ๋‹ˆ๋‹ค.๋งŒ์•ฝ Oracle์—์„œ use_yn ์ปฌ๋Ÿผ์„ Boolean ํƒ€์ž…์ฒ˜๋Ÿผ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ์—ˆ๋‹ค๋ฉด,MySQL๋กœ ๋งˆ์ด๊ทธ๋ ˆ์ด์…˜ํ•  ๋•Œ ์ด๋Ÿฌํ•œ ์ฐจ์ด๋กœ ์ธํ•ด ๋ฌธ์ œ๊ฐ€ ๋ฐœ์ƒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. SELECT * FROM table_name WHERE use_yn IS TRUE;โฌ‡๏ธSELECT * FROM table_name WHERE use_yn = 1; ๊ทธ๋ž˜์„œ mysql์—์„œ๋Š” ์œ„ SQL ๋Œ€๋กœ ์ž‘์„ฑํ–ˆ์„ ๋•Œ ์ž‘๋™๋˜์—ˆ์ง€๋งŒ,oracle์—์„œ๋Š” ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜์—ฌ ์•„๋ž˜์™€ ๊ฐ™์€ SQL๋กœ ์ˆ˜์ •ํ•ด์ฃผ์–ด์•ผ ํ•œ๋‹ค.

DB 2024.08.07

[CSS] rem๋‹จ์œ„

rem(root em) ๋‹จ์œ„๋Š” CSS์—์„œ ๊ธ€๊ผด ํฌ๊ธฐ ๋ฐ ๋ ˆ์ด์•„์›ƒ์„ ์ƒ๋Œ€์ ์œผ๋กœ ์„ค์ •ํ•˜๊ธฐ ์œ„ํ•ด ์‚ฌ์šฉ๋˜๋Š” ๋‹จ์œ„์ž…๋‹ˆ๋‹ค. rem์€ "root em"์˜ ์ค„์ž„๋ง๋กœ, ์ด๋Š” ๋ฌธ์„œ์˜ ๋ฃจํŠธ ์š”์†Œ()์˜ ๊ธ€๊ผด ํฌ๊ธฐ์™€ ๊ด€๋ จ์ด ์žˆ์Šต๋‹ˆ๋‹ค.๊ธฐ๋ณธ์ ์œผ๋กœ, 1rem์€ ๋ฃจํŠธ ์š”์†Œ์˜ ๊ธ€๊ผด ํฌ๊ธฐ์™€ ๋™์ผํ•ฉ๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด, ๋ธŒ๋ผ์šฐ์ €์˜ ๊ธฐ๋ณธ ์„ค์ •์—์„œ ๋ฃจํŠธ ์š”์†Œ์˜ ๊ธฐ๋ณธ ๊ธ€๊ผด ํฌ๊ธฐ๋Š” 16px์ž…๋‹ˆ๋‹ค. ์ด ๊ฒฝ์šฐ 1rem์€ 16px์„ ์˜๋ฏธํ•ฉ๋‹ˆ๋‹ค. ๋”ฐ๋ผ์„œ, font-size: 1rem;์€ 16px ํฌ๊ธฐ์˜ ๊ธ€๊ผด์„ ์„ค์ •ํ•˜๋Š” ๊ฒƒ์ž…๋‹ˆ๋‹ค. ๋งŒ์•ฝ ๋ฃจํŠธ ์š”์†Œ์˜ ๊ธ€๊ผด ํฌ๊ธฐ๊ฐ€ ๋ณ€๊ฒฝ๋˜๋ฉด, rem ๋‹จ์œ„๋กœ ์„ค์ •๋œ ์š”์†Œ๋“ค์˜ ํฌ๊ธฐ๋„ ์ด์— ๋”ฐ๋ผ ์ž๋™์œผ๋กœ ์กฐ์ •๋ฉ๋‹ˆ๋‹ค.์˜ˆ๋ฅผ ๋“ค์–ด, ๋ฃจํŠธ ์š”์†Œ์˜ ๊ธ€๊ผด ํฌ๊ธฐ๋ฅผ 20px๋กœ ์„ค์ •ํ•˜๋ฉด 1rem์€ 20px์„ ์˜๋ฏธํ•˜๊ฒŒ ๋ฉ๋‹ˆ๋‹ค. ์ด ๋ฐฉ์‹์€ ์ „์ฒด ๋ ˆ์ด์•„์›ƒ์„..

Front/CSS 2024.08.06

[DB][Oracle] DECODE

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DECODE.html SQL Language Reference docs.oracle.com DECODE๋Š” Oracle SQL์—์„œ ์กฐ๊ฑด์— ๋”ฐ๋ผ ๋‹ค๋ฅธ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ๋˜๋Š” ํ•จ์ˆ˜์ž…๋‹ˆ๋‹ค.๊ฐ„๋‹จํ•˜๊ฒŒ ์„ค๋ช…ํ•˜๋ฉด, ํŠน์ • ๊ฐ’์ด ์กฐ๊ฑด์— ๋งž์œผ๋ฉด ๊ทธ์— ํ•ด๋‹นํ•˜๋Š” ๊ฒฐ๊ณผ๋ฅผ ๋ฐ˜ํ™˜ํ•˜๊ณ ,๊ทธ๋ ‡์ง€ ์•Š์œผ๋ฉด ๊ธฐ๋ณธ๊ฐ’์ด๋‚˜ ๋‹ค๋ฅธ ์กฐ๊ฑด์— ๋”ฐ๋ฅธ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.DECODE๋Š” CASE ๋ฌธ์˜ ๊ฐ„๋‹จํ•œ ํ˜•ํƒœ๋กœ ์ƒ๊ฐํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. DECODE(ํ‘œํ˜„์‹, ์กฐ๊ฑด1, ๊ฒฐ๊ณผ1, ์กฐ๊ฑด2, ๊ฒฐ๊ณผ2, ..., ์กฐ๊ฑดN, ๊ฒฐ๊ณผN, ๊ธฐ๋ณธ๊ฐ’) ํ‘œํ˜„์‹: ๋น„๊ตํ•  ๊ฐ’์ž…๋‹ˆ๋‹ค.์กฐ๊ฑด1, ์กฐ๊ฑด2, ..., ์กฐ๊ฑดN: ํ‘œํ˜„์‹๊ณผ ๋น„๊ตํ•  ๊ฐ’์ž…๋‹ˆ๋‹ค.๊ฒฐ๊ณผ1, ๊ฒฐ๊ณผ2, ..., ๊ฒฐ..

DB 2024.08.05

String to UUID/ UUID to String

import java.nio.charset.StandardCharsets;import java.security.MessageDigest;import java.security.NoSuchAlgorithmException;import java.util.UUID;public class UUIDExample { public static void main(String[] args) { // ์ˆซ์ž ID๋ฅผ ๋ฌธ์ž์—ด๋กœ ๋ณ€ํ™˜ String name = "128478"; // ๋„ค์ž„์ŠคํŽ˜์ด์Šค UUID (์˜ˆ: URL ๋„ค์ž„์ŠคํŽ˜์ด์Šค) UUID namespace = UUID.fromString("6ba7b811-9dad-11d1-80b4-00c04fd430c8"); ..

IT์ง€์‹ 2024.08.04
728x90
๋ฐ˜์‘ํ˜•