sqlserver:
减去10小时: 时间类型:year | quarter | month | week | day | hour | minute | second
dateadd(hour,-10,Your_date)
oracle :
减去10小时:
sysdate()-10/24
sqlserver:
减去10小时: 时间类型:year | quarter | month | week | day | hour | minute | second
dateadd(hour,-10,Your_date)
oracle :
减去10小时:
sysdate()-10/24
转载于:https://www.cnblogs.com/lj821022/p/5166139.html