public static SqlExpression DateTimeCtor(
[Type(typeof(int))] SqlExpression year,
[Type(typeof(int))] SqlExpression month,
[Type(typeof(int))] SqlExpression day)
{
return(SqlDml.DateTimeConstruct(year, month, day));
}
public virtual void DateTimeConstructTest()
{
var select = SqlDml.Select();
select.Columns.Add(
SqlDml.DateTimeConstruct(2005, 5, 5));
select.Columns.Add(new DateTime(2005, 5, 5));
CompareColumnEquality(select);
}
public void Test014_13()
{
string nativeSql = @"select datetime('2011-11-16') AS BirthDay ";
SqlSelect select = SqlDml.Select();
select.Columns.Add(SqlDml.DateTimeConstruct(2011, 11, 16), "BirthDay");
Assert.IsTrue(CompareExecuteDataReader(nativeSql, select));
}
private static SqlExpression DateTimeConstruct(
SqlExpression year,
SqlExpression month,
SqlExpression day,
SqlExpression hour,
SqlExpression minute,
SqlExpression second,
SqlExpression millisecond)
{
return(SqlDml.DateTimePlusInterval(
SqlDml.DateTimeConstruct(year, month, day),
TimeSpanCompilers.GenericIntervalConstruct(0, hour, minute, second, millisecond)));
}
public virtual void DateTimeConstructTest()
{
CheckEquality(
SqlDml.DateTimeConstruct(DefaultDateTime.Year, DefaultDateTime.Month, DefaultDateTime.Day),
DefaultDateTime.Date);
}