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 怎么解决啊?
解决方案 »
- 100分求优化SQL
- .NET里面怎么写出ORADC的refresh方法?
- 急求oracle 9i客户端
- CREATE_SCHEDULE
- 数据库学习
- 急!!!Oracle 并发控制问题
- nvarchar类型的数据,exp/imp备份数据的时候出错,高手请进
- 如何用语句查看一个表的sql
- 如何取得table1.field3 = table2.field3的字段,加上table1.field3 is null的字段?
- 求助:oracle8.0.4能装到win2000 server中吗?我在线等!谢谢了!
- 紧急求助: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//