23,407
社区成员
发帖
与我相关
我的任务
分享请教：oracle中有个date型字段，想插入日期和时间该怎么写（为什么insert into table(to_char(StartTime,'yyyy-mm-dd')) values ('2002-0
请教：oracle中有个date型字段，想插入日期和时间该怎么写（为什么insert into table(to_char(StartTime,'yyyy-mm-dd')) values ('2002-02-23 2:00')不行）
...全文
请发表友善的回复…
发表回复
cxhz_cn 2002-02-27
- 打赏
- 举报
insert into table(time) values (to_date('2000-2-2','yyyy-dd-mm'))
cosmo 2002-02-27
- 打赏
- 举报
insert into table(to_char(StartTime,'yyyy-mm-dd')) values ....
is completely wrong, INSERT INTO TABLE ( column_name, ...).
to_char can be used on field value, not column_name.
is completely wrong, INSERT INTO TABLE ( column_name, ...).
to_char can be used on field value, not column_name.
cosmo 2002-02-27
- 打赏
- 举报
moreover, insert a date value should use
StartTime = to_date(......)
to_date is make a string to date format
StartTime = to_date(......)
to_date is make a string to date format
cosmo 2002-02-27
- 打赏
- 举报
(to_char(StartTime,'yyyy-mm-dd')) values ('2002-02-23 2:00')
you should match the pattern exactly
if YYYY-MM-DD, you should input 2002-02-23, no 2:00 after it
moreover, insert a date value should use
you should match the pattern exactly
if YYYY-MM-DD, you should input 2002-02-23, no 2:00 after it
moreover, insert a date value should use
