.NET Documentation
DataTo
Converts a value to a date, time, and time offset string for SQL.
Definition
Namespace: Aliquo.Core
Assembly: Aliquo.Core (in Aliquo.Core.dll) Version: 5.0.9179.22651
String with the value converted.
Assembly: Aliquo.Core (in Aliquo.Core.dll) Version: 5.0.9179.22651
C#
public static string ToSQLDateTimeOffset(
Object value,
string datePattern = "yyyy-MM-dd HH:mm:ss zzz",
string dateSymbol = "#",
bool minValueInYear1900 = true
)VB
Public Shared Function ToSQLDateTimeOffset (
value As Object,
Optional datePattern As String = "yyyy-MM-dd HH:mm:ss zzz",
Optional dateSymbol As String = "#",
Optional minValueInYear1900 As Boolean = true
) As StringParameters
- value Object
- Value to convert.
- datePattern String (Optional)
- Day pattern.
- dateSymbol String (Optional)
- Date symbol.
- minValueInYear1900 Boolean (Optional)
- Indicates if the minimum value is the year 1900.
Return Value
StringString with the value converted.
Remarks
Can return or CAST('yyyy-MM-dd HH:mm:ss zzz' AS DateTimeOffset).