# convert

## convert相关知识

• Convert word or html to wiki syntax
It will be annoying to convert a word document to wiki page manually. Some people should have to face this problem and solve this problem.I google the internet and&nbsp;find&nbsp;this useful online tools:http://toolserver.org/~diberri/cgi-bin/html2wiki/index.cgiNote: You can convert doc to html file with the help of Gmail, or just use the ‘Save as…’ menu in the word editor.BTW: The wiki syntax is so ugly in my eyes. Why don’t they use html syntax?It seems
• 【LEETCODE】模拟面试-108-Convert Sorted Array to Binary Search Tree
图源：新生大学题目：https://leetcode.com/problems/convert-sorted-array-to-binary-search-tree/Given an array where elements are sorted in ascending order, convert it to a height balanced BST.分析：Input: So we&#39;re given a sorted array in ascending order.**Output: ** To return the root of a Binary Search Tree.The corner case is when the input array is null or empty, then we will return null.To build a tree, we need to firstly find the root.And since it&#39;s a BST, wh
• SQLSERVER 日期函数convert、cast、dateadd
目的截取日期的年月&nbsp;&nbsp;&nbsp;&nbsp;SELECT&nbsp;LEFT&nbsp;(convert(varchar&nbsp;,字段,112),6)&nbsp;AS&nbsp;ym &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;表名结果取最近两个月的数据，注意YYYYMM是类似&#39;201803&#39;这种字符串的数据SELECT&nbsp;* &nbsp;&nbsp;FROM&nbsp;tablename &nbsp;where&nbsp;cast(YYYYMM+&#39;01&#39;&nbsp;as&nbsp;datetime)&gt;=(select&nbsp;DATEADD(month,-1,max(YYYYMM+&#39;01&#39;))&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
• SQL日期格式化应用大全
Sql Server 中一个非常强大的日期格式化函数Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AMSelect CONVERT(varchar(100), GETDATE(), 1): 05/16/06Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06Select CONVERT(varchar(100), GETDATE(), 4): 16.05.06Select CONVERT(varchar(100), GETDATE(), 5): 16-05-06Select CONVERT(varchar(100), GETDATE(), 6): 16 05 06Select CONVERT(varchar(100), GETDATE(), 7): 05 16, 06Select