SQL 查询日期取年/月/日

1，日期取年份

SELECT year(APPLY_TIME) AS TIME FROM SYS_ORG

2，日期取月份

SELECT month(APPLY_TIME) AS TIME FROM SYS_ORG

3，日期取天

SELECT day(APPLY_TIME) AS TIME FROM SYS_ORG