错误，其结果是DATE GOT NUMBER [英] Error it results is DATE GOT NUMBER

问题描述

SQL> CREATE TABLE sales ( ID INT NOT NULL, DATEn DATE, AMOUNT int);

Table created.

SQL> insert into sales values (1,2016-06-23,3600);
insert into sales values (1,2016-06-23,3600)
                                   *
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected DATE got NUMBER

正确的日期和时间命令是什么?

What are the correct date and time commands?

推荐答案

您应将列值转换为日期，请尝试以下操作:

You should convert your column value to date, try this:

insert into sales values (1,to_date('2016-06-23','yyyy-mm-dd'),3600);

这篇关于错误，其结果是DATE GOT NUMBER的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！