MySQL current函数常见用法有哪些
小樊
86
2024-07-14 12:13:19
- 获取当前日期和时间：SELECT CURRENT_TIMESTAMP;
- 获取当前日期：SELECT CURRENT_DATE;
- 获取当前时间：SELECT CURRENT_TIME;
- 获取当前日期和时间戳：SELECT UNIX_TIMESTAMP(CURRENT_TIMESTAMP);
- 获取当前年份：SELECT YEAR(CURRENT_DATE);
- 获取当前月份：SELECT MONTH(CURRENT_DATE);
- 获取当前日期的星期：SELECT DAYOFWEEK(CURRENT_DATE);
- 获取当前日期的周数：SELECT WEEK(CURRENT_DATE);
- 获取当前日期的月末日期：SELECT LAST_DAY(CURRENT_DATE);
- 获取当前日期的季度：SELECT QUARTER(CURRENT_DATE);