3,484
社区成员
发帖
与我相关
我的任务
分享在pb向oracle过程传date型参数时，报无效月份错误，调用过程错误！！！望指点
在pb向oracle过程传date型参数时，报无效月份错误，调用过程错误！！！给在我的机器上这样，不知道各位有没有遇到过这些问题？如何解决？
...全文
请发表友善的回复…
发表回复
wxjcn 2003-04-28
- 打赏
- 举报
where paydate='21-1月-2003'
to_char()
EXAMPLE:
SELECT TO_CHAR(HIREDATE,'Month DD, YYYY')
"New date format"
FROM emp
WHERE ename = 'SMITH'
New date format
-------------------------------
December 17, 1980
to_date()
EXAMPLE:
INSERT INTO bonus (bonus_date)
SELECT TO_DATE('January 15, 1989, 11:00 A.M.',
'Month dd, YYYY, HH:MI A.M.',
'NLS_DATE_LANGUAGE = American')
FROM DUAL
to_char()
EXAMPLE:
SELECT TO_CHAR(HIREDATE,'Month DD, YYYY')
"New date format"
FROM emp
WHERE ename = 'SMITH'
New date format
-------------------------------
December 17, 1980
to_date()
EXAMPLE:
INSERT INTO bonus (bonus_date)
SELECT TO_DATE('January 15, 1989, 11:00 A.M.',
'Month dd, YYYY, HH:MI A.M.',
'NLS_DATE_LANGUAGE = American')
FROM DUAL
jiezhi 2003-04-27
- 打赏
- 举报
use to_date/to_char to format datatime
