Oracle的CURRENT_TIMESTAMP函數(shù)用于返回當(dāng)前日期和時(shí)間的時(shí)間戳。以下是一些使用技巧:
SELECT CURRENT_TIMESTAMP FROM dual;
INSERT INTO table_name (timestamp_column) VALUES (CURRENT_TIMESTAMP);
SELECT * FROM table_name WHERE timestamp_column > CURRENT_TIMESTAMP - INTERVAL '1' HOUR;
CREATE TABLE table_name (
id NUMBER,
timestamp_column TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
SELECT CURRENT_TIMESTAMP + INTERVAL '1' DAY FROM dual;
總之,Oracle的CURRENT_TIMESTAMP函數(shù)非常有用,可以方便地獲取當(dāng)前日期和時(shí)間的時(shí)間戳,并可以在各種場景下進(jìn)行靈活的應(yīng)用。