Take the writing of various databases

zhaozj2021-02-16  44

Take the writing of various databases

Author: CCBZZP

1. ORACLE SELECT SYSDATE FROM DUAL 2. DB2 SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1 3. INFORMIX SELECT TODAY FROM TABLE 4. SQLSERVER SELECT GETDATE () FROM TABLE 5. SQLSERVER SELECT GETDATE () FROM TABLE 6. MYSQL mysql> select now ( ); mysql> select sysdate (); mysql> select current_date; mysql> select curtime (); mysql> select current_time; 7. FoxPro Select Date () from table

转载请注明原文地址:https://www.9cbs.com/read-24767.html

New Post(0)