| |
数据库中取当前日期的各种方法
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. mysql mysql> select now();
mysql> select sysdate();
mysql> select curdate();
mysql> select current_date;
mysql> select curtime();
mysql> select current_time;
6. max db sysdate
7. sybase getdate()
8. openbase sysdate
10. foxpro select date() from table
|
|
