MySQL current函數(shù)常見(jiàn)用法有哪些

小樊
86
2024-07-14 12:13:19
欄目: 云計(jì)算

  1. 獲取當(dāng)前日期和時(shí)間：SELECT CURRENT_TIMESTAMP;
  2. 獲取當(dāng)前日期：SELECT CURRENT_DATE;
  3. 獲取當(dāng)前時(shí)間：SELECT CURRENT_TIME;
  4. 獲取當(dāng)前日期和時(shí)間戳：SELECT UNIX_TIMESTAMP(CURRENT_TIMESTAMP);
  5. 獲取當(dāng)前年份：SELECT YEAR(CURRENT_DATE);
  6. 獲取當(dāng)前月份：SELECT MONTH(CURRENT_DATE);
  7. 獲取當(dāng)前日期的星期：SELECT DAYOFWEEK(CURRENT_DATE);
  8. 獲取當(dāng)前日期的周數(shù)：SELECT WEEK(CURRENT_DATE);
  9. 獲取當(dāng)前日期的月末日期：SELECT LAST_DAY(CURRENT_DATE);
  10. 獲取當(dāng)前日期的季度：SELECT QUARTER(CURRENT_DATE);

0 踩