web developer👩🏻‍💻

CURRENT_TIMESTAMP는 표준 SQL / NOW()는 비표준SQL이다. (결과는 동일하다.) NOW() SELECT NOW() 2021-09-02 11:21:39.028994+09 CURRENT_TIMESTAMP SELECT CURRENT_TIMESTAMP 2021-09-02 11:21:39.028994+09 CURRENT_DATE SELECT CURRENT_DATE 2021-09-02 https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT 9.9. Date/Time Functions and Operators 9.9. Date/Time Functions and Operators 9.9.1...

JDBC 연결 문법 -로컬에서 연결 시 : localhost or 127.0.0.1 -외부 연결 시 : 해당 외부 아이피 MySQL / MariaDB 3306 jdbc:mysql://127.0.0.1:3306/[database name] Oracle 1521 jdbc:oracle:thin:@127.0.0.1:1521:[database name] MS-SQL 1433 jdbc:sqlserver://127.0.0.1:1433;database=[database name]; PostgreSQL 5432 jdbc:postgresql://127.0.0.1:5432/[database name] Tibero 8629 jdbc:tibero:thin:@127.0.0.1:8629:[database name] 참고 : jav..