赛捷软件论坛's Archiver

vicky.yu 发表于 2024-8-1 10:08

sql日期表达式

日期表达式返回当前系统日期和时间值:

SQL>  SELECT CURRENT_TIMESTAMP;
+---------------------+
| Current_Timestamp   |
+---------------------+
| 2009-11-12 06:40:23 |
+---------------------+
1 row in set (0.00 sec)
 另一个日期表达式如下所示:

SQL>  SELECT  GETDATE();;
+-------------------------+
| GETDATE                 |
+-------------------------+
| 2009-10-22 12:07:18.140 |
+-------------------------+
1 row in set (0.00 sec)

页: [1]

Powered by Discuz! Archiver 7.2  © 2001-2009 Comsenz Inc.