/// <summary>
/// Returns the command text for a DbCommand to obtain the DateTime from the database.
/// Note: This operation will make a database call.
/// if ReturnAsAlias is not null, it will be the alias
/// </summary>
/// <param name="dbDateType">Enumeration value indicating whether time is local or UTC;
/// default is UTC.</param>
/// <param name="returnAsAlias">What the return column will be called</param>
/// <returns>Back-end compliant command text for returning server time</returns>
public override string GetServerTimeCommandText(EnumDateTimeLocale dbDateType, string returnAsAlias)
{
return(string.Format("select {0} from sysibm.dual", GetDbTimeAs(dbDateType, returnAsAlias)));
}
/// <summary>
/// Returns the backend specific function for current datetime
/// as a string e.g. sysdate or getdate() to be used in a seperate command
/// if ReturnAsAlias is not null, it will be the alias
/// </summary>
/// <param name="dbDateType">The format type of the date function</param>
/// <param name="returnAsAlias">What the return column will be called</param>
/// <returns>Backend specific function for current date time</returns>
public override string GetDbTimeAs(EnumDateTimeLocale dbDateType, string returnAsAlias)
{
string dbTime = dbDateType == EnumDateTimeLocale.Local ? "current_timestamp" : "current_timestamp - current_timezone";
return(dbTime + (string.IsNullOrEmpty(returnAsAlias) ? "" : " as " + returnAsAlias));
}
/// <summary>
/// Returns the backend specific function for current datetime
/// to be used in an sql command.
/// if ReturnAsAlias is not null, it will be the alias for the function
/// </summary>
/// <param name="dbDateType">The format type of the date function(local, UTC, Default (UTC))</param>
/// <param name="returnAsAlias">What the return column will be called</param>
/// <returns>Backend specific function for current date time including milliseconds</returns>
public override string GetDbTimeAs(EnumDateTimeLocale dbDateType, string returnAsAlias)
{
string dbTime = dbDateType == EnumDateTimeLocale.Local ? "getdate()" : "getutcdate()";
return(dbTime + (string.IsNullOrEmpty(returnAsAlias) ? "" : " as " + returnAsAlias));
}
/// <summary> /// Returns the command text for a DbCommand to obtain the DateTime from the database. /// Note: This operation will make a database call. /// if ReturnAsAlias is not null, it will be the alias /// </summary> /// <param name="dbDateType">Enumeration value indicating whether time is local or UTC; /// default is UTC.</param> /// <param name="returnAsAlias">What the return column will be called</param> /// <returns>Back-end compliant command text for returning server time</returns> public abstract string GetServerTimeCommandText(EnumDateTimeLocale dbDateType, string returnAsAlias);
/// <summary> /// Returns the backend specific function for current datetime /// to be used in an sql command. /// if ReturnAsAlias is not null, it will be the alias for the function /// </summary> /// <param name="dbDateType">The format type of the date function(local, UTC, Default (UTC))</param> /// <param name="returnAsAlias">What the return column will be called</param> /// <returns>Backend specific function for current date time including milliseconds</returns> public abstract string GetDbTimeAs(EnumDateTimeLocale dbDateType, string returnAsAlias);
/// <summary>
/// Returns the backend specific function for current datetime
/// to be used in an sql command.
/// if ReturnAsAlias is not null, it will be the alias for the function
/// </summary>
/// <param name="dbDateType">The format type of the date function(local, UTC, Default (UTC))</param>
/// <param name="returnAsAlias">What the return column will be called</param>
/// <returns>Backend specific function for current date time including milliseconds</returns>
public override string GetDbTimeAs(EnumDateTimeLocale dbDateType, string returnAsAlias)
{
string dbTime = dbDateType == EnumDateTimeLocale.Local ? "systimestamp" : "sys_extract_utc(systimestamp)";
return(dbTime + (string.IsNullOrEmpty(returnAsAlias) ? "" : " as " + returnAsAlias));
}
