如何在ORACLE中插入时间?

[lenoray]

Cmd.CommandText = "INSERT INTO \"T_News\" (ID, TITLE, CONTENT, AUTHOR, RELEASEDATE, CLASSID) VALUES ('" + ID + "','" + Title + "','" + Content + "','" + Author + "',to_date('" + DateTime.Now + "','yyyy-mm-dd-hh:mm:ss'),'" + ClassID + "')";

需要插入年月日,小时,分钟,妙数

顺便问下,如果插入数据库时间?
现在的DATETIME.NOW是本机时间,怎么插入数据库时间,望大侠帮助!

[lenoray]

先谢谢了,但"select sysdate from dual"只返回日期,我还要时间的

应该怎么返回时间?

[junqiang]

插入系统日期时间：
insert into tbl_user values('03','dd','001', sysdate)

sysdate返回的是日期加时间的格式，精确到秒。

[lenoray]

知道了

select to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') as now from dual;

[lenoray]

会了

select to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') as now from dual;

[yiyi0518]

select sysdate from dual

获取数据库时间

[yiyi0518]

最好把数据库类里定义一个函数获取数据库时间，在程序里调用该方法~~~

[sdenli]

in sql server we can use the function --getdate() but i don't know that in oracle

[lenoray]

格式知道了

Cmd.CommandText = "INSERT INTO \"T_News\" (ID, TITLE, CONTENT, AUTHOR, RELEASEDATE, CLASSID) VALUES ('" + ID + "','" + Title + "','" + Content + "','" + Author + "',to_date('" + DateTime.Now + "','YYYY:MM:DD:HH24:MI:SS'),'" + ClassID + "')";

但是怎么插入服务器时间????