//https://tableplus.com/blog/2018/09/ms-sql-server-how-to-get-date-only-from-datetime-value.html
	/*
	1. Use CONVERT to VARCHAR:

CONVERT syntax:

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )  

In this case, date only, you we are gonna run this query:

SELECT CONVERT(VARCHAR(10), getdate(), 111);

It returns 2018/09/01 for my test.

The style we used just now is 111, which is yyyy/mm/dd. There are many other style you can choose from. Here are some common types:
Style 	How it’s displayed
101 	mm/dd/yyyy
102 	yyyy.mm.dd
103 	dd/mm/yyyy
104 	dd.mm.yyyy
105 	dd-mm-yyyy
110 	mm-dd-yyyy
111 	yyyy/mm/dd
106 	dd mon yyyy
107 	Mon dd, yyyy

Because each type generates a different length, so you should define the right varchar length then.

	*/