Date conversion problem in sql server

rabbitwcm

To develop a database with VC, you need to get the date in two edit boxes, one for the year and the other for the month. For example: 2017 1
To convert the input character into a date type, the code: convert(datetime,'yyyy-mm') An error message appears when an error occurs when converting the character to datetime. Please help to change it!

啊啦是奶牛

'yyyy-mm' changed to'yyyy-mm-dd'

gaoqingfeng

Is it converted in VC or in database?

knightzk

Date format must include date

knightzk

Is to include the year, month, and day

cv4bf5d65fd

select convert(datetime,'2020-01-01')

rabbitwcm

sql.Format("select start_time,end_time from leave_info_tab "
"where personID='%s'and"
"start_time> (convert(datetime,'yyyy-mm-dd' )) "
"and end_time<(convert(datetime,'yyyy-mm-dd' )) ",
strPersonID,strMonthStart,strMonthEnd);
This is a part of the statement, and an error appears when an error occurs when converting from a character to a datetime

qfeng7

strMonthStart and strMonthEnd are not called in it, they must be called separately in the convert