mysql - 执行查询时出错

Question

我收到以下代码的语法错误“executeQuery 无法解析或不是字段”

ResultSet rsstore=stmt.executeQuery("SELECT FROM_UNIXTIME((dateOfBirth/1000), "%W, %M %d, %Y") DOB from QA_DATA_MART.CUSTOMER where programId='"+ProgrameID+"' and customerId='300000002';");

Answer 1

也许，您对引号有疑问，请在查询中使用单引号:

ResultSet rsstore=stmt.executeQuery("SELECT 
FROM_UNIXTIME((dateOfBirth/1000), '%W, %M %d, %Y') from 
QA_DATA_MART.CUSTOMER where programId='"+ProgrameID+"' and 
customerId='300000002';");

为什么需要 DOB？