oracle 日期插入时报这个错　ORA-01861: literal does not match format string #1701

New Issue

4color · 2020-06-03T09:32:34Z

4color commented

2020-06-03 09:32:34 +00:00

一直没找到解决办法，后来改了源码才可以。是不是哪里搞得不对。
case schemas.DateTime, schemas.TimeStamp, schemas.Varchar:
// !DarthPestilane! format time when sqlTypeName is schemas.Varchar.
//20200530
if dialect.URI().DBType == schemas.ORACLE {
v = t
} else {
v = t.Format("2006-01-02 15:04:05")
}
https://gitea.com/xorm/xorm/src/branch/master/dialects/time.go#L21

一直没找到解决办法，后来改了源码才可以。是不是哪里搞得不对。<br /> case schemas.DateTime, schemas.TimeStamp, schemas.Varchar: <br /> // !DarthPestilane! format time when sqlTypeName is schemas.Varchar. //20200530 if dialect.URI().DBType == schemas.ORACLE { v = t } else { v = t.Format("2006-01-02 15:04:05") } <br /> [ https://gitea.com/xorm/xorm/src/branch/master/dialects/time.go#L21](http://)

lunny added the

db

oracle

label 2020-06-04 01:27:27 +00:00

lunny commented

2020-06-04 01:34:36 +00:00

duplicated with #1641

lunny closed this issue

2020-06-04 01:34:36 +00:00

Sign in to join this conversation.