Search Result For "convert"

• [MS-SQL] Tree Menu

  2018.08.14 | DevDream

  WITH TREE_MENU AS ( SELECT MENU_ID , PARENT_ID , MENU_NAME , DEPTH , SORT , CONVERT(VARCHAR(100), MENU_ID) GROUP_ID , CONVERT(VARCHAR(100), MENU_NAME) TREE_MENU_NAME FROM MENU WHERE PARENT_ID = '' UNION ALL SELECT ...

• [MS-SQL] 날짜 및 시간 변환

  2018.08.13 | DevDream

  SELECT CONVERT(VARCHAR(19), GETDATE(), 0); -- MM DD YYYY H:MM SELECT CONVERT(VARCHAR(10), GETDATE(), 1); -- MM/DD/YY SELECT CONVERT(VARCHAR(8), GETDATE(), 2); -- YY.MM.DD SELECT CONVERT(VARCHAR(8), GETDATE(), 3); -- DD/MM/YY SELECT CONVERT(VARCHAR(8), GETDATE(), 4); -- DD.MM.YY SELECT CONVERT(VARCHAR(8), GETDATE(), 5); -- DD-MM-YY SELECT CONVERT(VARCHAR(8), GETD ...