表达式mysql msaccess中未定义函数“str\u to\u date”

mv1qrgav 于 2021-06-21 发布在 Mysql

关注(0)|答案(1)|浏览(265)

我得到以下错误：
system.data.oledb.OLEDBEException（0x80040e14）：表达式中未定义函数“str_to_date”。
当我运行此查询时

SELECT 
    ProductCode, 
    Description, 
    SUM(Quantity) as Quantity, 
    STR_TO_DATE(REPLACE(DateIn, '-', '/'), '%m/%d/%Y') as DateIn 
FROM 
    Product as P, 
    StockIn as S 
WHERE 
    S.ProductNo = P.ProductNo 
    AND 
    STR_TO_DATE(REPLACE(DateIn, '-', '/'), '%m/%d/%Y') BETWEEN '" + StartDate.ToString("yyyy-MM-dd") + "' AND '" + EndDate.ToString("yyyy-MM-dd") + "' GROUP BY P.ProductNo, DateIN ORDER BY DateIn, Description";

sql mysql ms-access

来源：https://stackoverflow.com/questions/48316763/undefined-function-str-to-date-in-expression-mysql-msacess

1条答案

按热度按时间

xmjla07d1#

尝试使用access sql：

"SELECT
    ProductCode, 
    Description, 
    SUM(Quantity) as Quantity, 
    DateValue(DateIn) as DateIn 
FROM 
    Product as P, 
    StockIn as S 
WHERE 
    S.ProductNo = P.ProductNo 
    AND 
    DateValue(DateIn) BETWEEN #" + StartDate.ToString("yyyy-MM-dd") + "# AND #" + EndDate.ToString("yyyy-MM-dd") + "# GROUP BY P.ProductNo, DateValue(DateIn) ORDER BY DateValue(DateIn), Description";

赞(0）回复(0）举报 2021-06-21

我来回答

表达式mysql msaccess中未定义函数“str\u to\u date”

1条答案

相关问题

热门标签

最新问答