SQL“无效月份" [英] SQL "not a valid month"

问题描述

我在sql中有一个表如下:

I have a table in sql as follows:

CREATE TABLE Reserves(
    sid INTEGER,
    bid INTEGER,
    day DATE,
    PRIMARY KEY (sid, bid, day),
    FOREIGN KEY (sid) REFERENCES Sailors,
    FOREIGN KEY (bid) REFERENCES Boats
);

我正在尝试插入其中:

INSERT INTO Reserves VALUES(22, 101, '01-01-1998');

但我收到错误消息:ORA-01843:无效月份

But I get the error: ORA-01843: not a valid month

这是一个 Oracle 数据库.我不确定我的日期格式有什么问题.

This is an Oracle db. I'm not sure what's wrong with my date format.

推荐答案

目前还不清楚您想要哪个，因此您可以尝试:

It's not entirely clear which you wanted, so you could try:

• 对于月-日-年格式:

• For month-day-year format:

INSERT INTO Reserves VALUES(22, 101, TO_DATE('01-01-1998','MM-DD-YYYY'));

对于日-月-年格式:

INSERT INTO Reserves VALUES(22, 101, TO_DATE('01-01-1998','DD-MM-YYYY'));

另外，推荐阅读:Oracle 函数:TO_DATE

这篇关于SQL“无效月份"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！