INSERT INTO tb_reader
(name,sex,barcode,vocation,birthday,
paperType,paperNO,tel,email,createDate,operator,re,typeid)
values
('asdf','男','sfdsdf','asdf',to_date('2009-04-06 16:55:11','yyyy-mm-dd hh:mi:ss'),'身份证','sdfasdf','asdfasdf','asdfasdf',to_date('2009-04-19 10:00:00','yyyy-mm-dd hh:mi:ss'),'zhou','asdfasdfasd',8);
这里提示小时值必须在 1-12 怎么解决啊?
(name,sex,barcode,vocation,birthday,
paperType,paperNO,tel,email,createDate,operator,re,typeid)
values
('asdf','男','sfdsdf','asdf',to_date('2009-04-06 16:55:11','yyyy-mm-dd hh:mi:ss'),'身份证','sdfasdf','asdfasdf','asdfasdf',to_date('2009-04-19 10:00:00','yyyy-mm-dd hh:mi:ss'),'zhou','asdfasdfasd',8);
这里提示小时值必须在 1-12 怎么解决啊?
解决方案 »
- 关于拼接两张表的问题
- 用eclipse编写的jsp连接oracle总是出错
- 求一统计分析SQL
- 高分求一SQL语句的写法,详情请进,应使用变量
- 求oracle数组写法
- 有metalink的能帮我下个p3423540_9204_LINUX64.zip补丁吗?
- 关于带参数的脚本文件,求教!
- 如何查询某表的约束情况
- 在linux下import一个windows下建的库的DMP文件,产生了乱码!
- 我在表中设置了一个自增字段REC_ID,我在插入的时候用了表名.nextval,怎么不对??
- 紧急求助:64位xp系统安装oracle8.17时出现错误ora-12546:TNS许可被拒绝
- 向大家请教一个SQL(4)
INSERT INTO tb_reader
(name,sex,barcode,vocation,birthday,
paperType,paperNO,tel,email,createDate,operator,re,typeid)
values
('asdf','男','sfdsdf','asdf',to_date('2009-04-06 16:55:11','yyyy-mm-dd hh24:mi:ss')
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual; //日期转化为字符串
select to_char(sysdate,'yyyy') as nowYear from dual; //获取时间的年
select to_char(sysdate,'mm') as nowMonth from dual; //获取时间的月
select to_char(sysdate,'dd') as nowDay from dual; //获取时间的日
select to_char(sysdate,'hh24') as nowHour from dual; //获取时间的时
select to_char(sysdate,'mi') as nowMinute from dual; //获取时间的分
select to_char(sysdate,'ss') as nowSecond from dual; //获取时间的秒
select to_date('2004-05-07 13:23:44','yyyy-mm-dd hh24:mi:ss') from dual//