MESSAGE

DevDream
  • Notice Board

  • Free Board

  • Fishing Board

  • Guest Board

  • Programming

    • jQeury / javascript
    • ASP
    • JAVA
    • MS-SQL
  • Blog

    • Gallery Board
    • Profile
  • DevDream

    • Clean Board
    • Statistics
    • History
Search Result
  • Login

  • Join

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 ...

    ©2018, DevDream.