--触发器的应用限制用户写入 --具体功能:在写入一个表之前,限制必须要在周一到周5和工作时间8:00~18:00 create or replace trigger tri3 before insert on trigger_t declare --声明时间 v_dt integer; begin select to_number(to_char(sysdate,'hh24'))into v_dt from dual; then dbms_output.put_line('可以'); else
自动更新修改时间: mysql> create table z(a int ,b timestamp on update current_timestamp); mysql> insert into z ,current_timestamp; mysql> select * from z; +------+---------------------+ | a | b | +------+---------------------+ | | -- :: | +------+--------
public class Test{public static void main (String args []){ java.util.Date a = new java.util.Date();System.out.println(a);java.sql.Date b = new java.sql.Date(a.getTime());System.out.println(b);java.sql.Time c = new java.sql.Time(a.getTime());System.o