DATEADD(day, - 7, DATEADD(wk, DATEDIFF(wk, 0, GETDATE()),0))) AND (al.CreateTime <= 问下面sqlserver 的日期函数如何找到mysql的日期函数对应 DATEADD(day, - 7, DATEADD(wk, DATEDIFF(wk, 0, GETDATE()),0))) AND (al.CreateTime <= DATEADD(millisecond, - 10, DATEADD(wk, DATEDIFF(wk, 0, GETDATE()), 0))) mysql好象好多 没有sqlserver简洁

by liyihongcug - MySQL - 2006-12-11 11:04:16 阅读（1811） 回复（3）