sysdate 可以精确到秒吗 怎么写代码?麻烦差个数据
http://smartan.iteye.com/blog/1225401CREATE TABLE Orders
(
Id_O int NOT NULL,
OrderNo int NOT NULL,
Id_P int,
OrderDate date DEFAULT SYSDATE
);
http://smartan.iteye.com/blog/1225401CREATE TABLE Orders
(
Id_O int NOT NULL,
OrderNo int NOT NULL,
Id_P int,
OrderDate date DEFAULT SYSDATE
);
你sqlplus连接到数据库后,执行:
alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
然后再执行:
select sysdate from dual;
就可以看到时间是精确到秒的喽!~~~
SYSDATE
-------------------
2011-11-01 08:54:35