有段時間沒用這些語法，會忘光光

所以就來簡單記錄一下~

(也可以直接請chatGPT幫忙產 🤪，懶人~)

拆解日期

Select GETDATE() as '當前日期',
	   DateName(year, GETDATE()) as '年',
	   DateName(month, GETDATE()) as '月',
	   DateName(day, GETDATE()) as '日',
	   DateName(dw, GETDATE()) as '星期',
	   DateName(week, GETDATE()) as '周數',
	   DateName(hour, GETDATE()) as '時',
	   DateName(minute, GETDATE()) as '分',
	   DateName(second, GETDATE()) as '秒'

上述語法得出的結果如下:

result-convert-date