sql 语句时间字段问题
insert into t_gbit_2_video (n_trial_sn,n_trial_sub_sn,c_ndh,c_ajzh,c_ajbh,c_courtid,d_start,d_end,n_length,c_multi,c_result,c_filepath,c_filename,c_judge,c_tape) values( '3','1','2006','230911','579','14','2006-12-1 19:28:59','2006-12-1 19:29:04','5','0','3','\\172.19.200.254\data','2006_12_01_19_28_59_2006_230911_579.mp4','Judge','' )
上面的时间字段有问题'2006-12-1 19:28:59'，用单引号有问题，请问用什么
问题点数：100、回复次数：4Top
1 楼jiangsheng（蒋晟.Net[MVP]）回复于 2006-12-02 03:49:43 得分 40
use TO_DATE functionTop
2 楼caixia615（＊^_^＊)‵My ɡīr!.ˊ想念妳ˋ 。(＊^_^＊）回复于 2006-12-02 08:47:40 得分 0
LZ是不是类型定义错了,是用单引号的..Top
3 楼caixia615（＊^_^＊)‵My ɡīr!.ˊ想念妳ˋ 。(＊^_^＊）回复于 2006-12-02 08:56:10 得分 60
create table t_gbit_2_video(n_trial_sn char(10),n_trial_sub_sn char(10),c_ndh char(10),c_ajzh char(10),c_ajbh char(10),c_courtid char(10),d_start datetime,d_end datetime,
n_length char(10),c_multi char(20),c_result char(100),c_filepath char(100),c_filename char(100),c_judge char(100),c_tape char(100))
insert into t_gbit_2_video
(n_trial_sn,n_trial_sub_sn,c_ndh,
c_ajzh,c_ajbh,c_courtid,d_start,d_end,
n_length,c_multi,c_result,c_filepath,c_filename,c_judge,c_tape)
values( '3','1','2006','230911','579','14','2006-12-1 19:28:59','2006-12-1 19:29:04','5','0','3','\\172.19.200.254\data','2006_12_01_19_28_59_2006_230911_579.mp4','Judge','' )
select * from t_gbit_2_video
结果：
n_trial_sn n_trial_sub_sn c_ndh c_ajzh c_ajbh c_courtid d_start d_end n_length c_multi c_result c_filepath c_filename c_judge c_tape
---------- -------------- ---------- ---------- ---------- ---------- ------------------------------------------------------ ------------------------------------------------------ ---------- -------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------
3 1 2006 230911 579 14 2006-12-01 19:28:59.000 2006-12-01 19:29:04.000 5 0 3 \\172.19.200.254\data 2006_12_01_19_28_59_2006_230911_579.mp4 Judge
（所影响的行数为 1 行）
Top
4 楼angeldream122（水晶）回复于 2006-12-02 11:01:59 得分 0
我的字段是DATE类型。怎么用TO_DATE function？
caixia615(紫瞳) ：你意思说类型错误？可是它表里面原来的数据都是这个形式的，我改字段类型的话，说需要这个列为空才行Top
