AppendComparisonDateLocalToUtc Method

Member of ISSqlWhereBuilder
Append a UTC Date comparison to the SQL Where clause. The date is converted to UTC dates before the date is appended to the SQL Where clause.

<para> If value = Nothing then the SQL Where clause will use the correct IS Null syntax. </para> <para> WARNING: The supplied date parameter will be converted from local to UTC regardless of the date's DateTimeKind, e.g., even if the DateTimeKind is 'Utc', it will still be adjusted to universal time as if it were a local date. </para>

Syntax

ISSqlWhereBuilder.AppendComparisonDateLocalToUtc(fieldName, operator, value)

Parameters

NameTypeOptionalByRefDescription
fieldName String The compare field name.
operator String The operator, e.g. =,&lt;&gt;,&lt;=.
value Date The date to compare in Local time.
Member of:
ISSqlWhereBuilder
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0