날아보자!

날짜함수 date_format()에서 대소문자에 따라 표기되는 결과가 달라질 수 있다. select now(); select curdate(); select curtime(); 2021-11-08 05:19:46 2021-11-08 05:20:14 select date_format(now() , '%Y-%m-%d %H:%i:%s'); select date_format(now(), '%Y-%m-%d'); select date_format(now(), '%Y.%m.%d %H:%i:%s') 2021-11-08 03:36:37 // YYYY-MM-DD HH:MM:SS 2021-11-08 // YYYY-MM-DD 2021.11.08 03:40:38 // YYYY.MM.DD HH:MM:SS select date_a..

MSSQL MySQL 결과 날짜함수 (yyyy-mm-dd hh:mm:ss.sss) convert(datetime, getdate(), 102) DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s') 2021-11-08 12:18:10.730 날짜함수 (yyyy.mm.dd) convert(varchar(10), getdate(), 102) DATE_FORMAT(NOW() , '%Y.%m.%d') 2021.11.08 날짜함수 (yyyy-mm-dd) convert(varchar(10), getdate(), 23) DATE_FORMAT(NOW() , '%Y-%m-%d') 2021-11.08 날짜더하기 dateadd(day, 1, getdate()) DATE_ADD(NOW(), INTERVAL 1..

1. w3schools https://www.w3schools.com/SQL/trymysql.asp?filename=trysql_func_mysql_instr MySQL Tryit Editor v1.0 WebSQL stores a Database locally, on the user's computer. Each user gets their own Database object. WebSQL is supported in Chrome, Safari, and Opera. If you use another browser you will still be able to use our Try SQL Editor, but a different version, usin www.w3schools.com 2. sqlfidd..

Julia conducted a 15 days of learning SQL contest. The start date of the contest was March 01, 2016 and the end date was March 15, 2016. Write a query to print total number of unique hackers who made at least 1 submission each day (starting on the first day of the contest), and find the hacker_id and name of the hacker who made maximum number of submissions each day. If more than one such hacker..