55 references to DATEPART
System.Data.Linq (55)
SqlClient\Common\SqlFactory.cs (5)
244SqlExpression ns = DATEPART("NANOSECOND", timeSpan); 245SqlExpression ms = DATEPART("MILLISECOND", timeSpan); 246SqlExpression ss = DATEPART("SECOND", timeSpan); 247SqlExpression mi = DATEPART("MINUTE", timeSpan); 248SqlExpression hh = DATEPART("HOUR", timeSpan);
SqlClient\Query\SqlMethodCallConverter.cs (50)
1065SqlExpression ns = this.sql.DATEPART("NANOSECOND", mc.Arguments[0]); 1066SqlExpression ss = this.sql.DATEPART("SECOND", mc.Arguments[0]); 1067SqlExpression mm = this.sql.DATEPART("MINUTE", mc.Arguments[0]); 1068SqlExpression hh = this.sql.DATEPART("HOUR", mc.Arguments[0]); 1123SqlExpression ns = sql.DATEPART("NANOSECOND", mc.Arguments[0]); 1124SqlExpression ss = sql.DATEPART("SECOND", mc.Arguments[0]); 1125SqlExpression mi = sql.DATEPART("MINUTE", mc.Arguments[0]); 1126SqlExpression hh = sql.DATEPART("HOUR", mc.Arguments[0]); 1345SqlExpression ns = sql.DATEPART("NANOSECOND", right); 1346SqlExpression ss = sql.DATEPART("SECOND", right); 1347SqlExpression mi = sql.DATEPART("MINUTE", right); 1348SqlExpression hh = sql.DATEPART("HOUR", right); 2181return sql.DATEPART(datePart, exp); 2194SqlExpression ms = sql.DATEPART("MILLISECOND", exp); 2195SqlExpression ss = sql.DATEPART("SECOND", exp); 2196SqlExpression mi = sql.DATEPART("MINUTE", exp); 2197SqlExpression hh = sql.DATEPART("HOUR", exp); 2214SqlExpression hours = sql.DATEPART("HOUR", exp); 2215SqlExpression minutes = sql.DATEPART("MINUTE", exp); 2216SqlExpression seconds = sql.DATEPART("SECOND", exp); 2217SqlExpression milliseconds = sql.DATEPART("MILLISECOND", exp); 2227SqlExpression sqlDay = sql.DATEPART("dw", exp); 2246this.sql.Multiply(sql.ConvertToBigint(sql.DATEPART("HOUR", exp)), 3600000000000), 2247this.sql.Multiply(sql.ConvertToBigint(sql.DATEPART("MINUTE", exp)), 60000000000), 2248this.sql.Multiply(sql.ConvertToBigint(sql.DATEPART("SECOND", exp)), 1000000000), 2249sql.DATEPART("NANOSECOND", exp)) 2258this.sql.Multiply(sql.DATEPART("HOUR", exp), 3600000), 2259this.sql.Multiply(sql.DATEPART("MINUTE", exp), 60000), 2260this.sql.Multiply(sql.DATEPART("SECOND", exp), 1000), 2261this.sql.Divide(sql.ConvertToDouble(sql.ConvertToBigint(sql.DATEPART("NANOSECOND", exp))), 1000000) 2268this.sql.Multiply(sql.DATEPART("HOUR", exp), 3600), 2269this.sql.Multiply(sql.DATEPART("MINUTE", exp), 60), 2270this.sql.DATEPART("SECOND", exp), 2271this.sql.Divide(sql.ConvertToDouble(sql.ConvertToBigint(sql.DATEPART("NANOSECOND", exp))), 1000000000) 2278this.sql.Multiply(sql.DATEPART("HOUR", exp), 60), 2279this.sql.DATEPART("MINUTE", exp), 2280this.sql.Divide(sql.ConvertToDouble(sql.DATEPART("SECOND", exp)), 60), 2281this.sql.Divide(sql.ConvertToDouble(sql.ConvertToBigint(sql.DATEPART("NANOSECOND", exp))), 60000000000) 2288this.sql.DATEPART("HOUR", exp), 2289this.sql.Divide(sql.ConvertToDouble(sql.DATEPART("MINUTE", exp)), 60), 2290this.sql.Divide(sql.ConvertToDouble(sql.DATEPART("SECOND", exp)), 3600), 2291this.sql.Divide(sql.ConvertToDouble(sql.ConvertToBigint(sql.DATEPART("NANOSECOND", exp))), 3600000000000) 2299this.sql.DATEPART("HOUR", exp), 2300this.sql.Divide(sql.ConvertToDouble(sql.DATEPART("MINUTE", exp)), 60), 2301this.sql.Divide(sql.ConvertToDouble(sql.DATEPART("SECOND", exp)), 3600), 2302this.sql.Divide(sql.ConvertToDouble(sql.ConvertToBigint(sql.DATEPART("NANOSECOND", exp))), 3600000000000)), 2309return this.sql.DATEPART("MILLISECOND", exp); 2314return this.sql.DATEPART("SECOND", exp); 2319return this.sql.DATEPART("MINUTE", exp); 2324return this.sql.DATEPART("HOUR", exp);