Avatar of Peter Chan
Peter Chan
Flag for Hong Kong asked on

Problem to the script

Here is the error
 
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '%m-%d %H:%i:%s') as in_ti
me_dscr,  date_format(p.stockout_time,'%Y-%m-%d %H:%i:%' at line 1
 

Open in new window

got within VS, while this is the script
 
                sql = @"select " +
                    " null as row_num, " +
                    " date_format(p.in_time,'%Y-%m-%d %H:%i:%s') as in_time_dscr, " +
                    " date_format(p.stockout_time,'%Y-%m-%d %H:%i:%s') as stockout_time_dscr, " +
                    " date_format(ADDDATE(p.store_rcv_time, " + package_expiry_day_vg.ToString() + "), '%c月%e日') as expiry_date_chi, " +
                    " date_format(ADDDATE(p.store_rcv_time, " + package_expiry_day_vg.ToString() + "), '%D %b') as expiry_date_eng, " +
                    " c_s.sms_addr_eng, " +
                    " c_s.sms_addr_chi, " +
                    " c_s.store_no, " +
                    " p.*  " +
                    " from package_vg p  " +
                    " left join c_store_vg c_s on c_s.dscr = p.store_dscr " +
                    " where p.deleted = '0' " +
                    " and (p.phone like '9%' or p.phone like '6%' or p.phone like '5%') " +
                    " and length(trim(p.phone)) = 8 " +
                    " and c_s.send_sms = 1 " +
                    " and (p.status = 'store_rcv' or p.status = 'store_app_rtn') " +
                    " and p.sms_send = 0 " +
                    " and date_format(p.store_rcv_time,'%Y-%m-%d') >= " + DBUtil.GetSqlString(From_Date.ToString(DBUtil.DATE_FORMAT)) + " " +
                    " and date_format(p.store_rcv_time,'%Y-%m-%d') < " + DBUtil.GetSqlString(To_Date.ToString(DBUtil.DATETIME_FORMAT)) + " " +
                    " order by p.id";
					

Open in new window

why?
C#MySQL ServerProgramming

Avatar of undefined
Last Comment
ste5an

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
ste5an

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Peter Chan

ASKER
Sorry, but why do I get the problem mentioned?
ste5an

Use line breaks to get a better line number..

Also output the string and before executing in and run it in the workbench.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes