Platforms to show: All Mac Windows Linux Cross-Platform

Back to SQLDateTimeMBS class.

SQLDateTimeMBS.Constructor(StringValue as String)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 21.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Initialized a date time value from a string.
Example
Dim d As New SQLDateTimeMBS("2021-04-12T18:46:16.242")
msgbox d.StringValue

Dim d2 As New SQLDateTimeMBS("now")
MsgBox d2.StringValue

You can pass "now" for current time, a string containing a double value for seconds since epoche or a string formatted with SQL datetime. Either with T or space as separator. If fraction is given, it should be 3 digits for milliseconds.

See also:

SQLDateTimeMBS.Set(DateTimeValue as DateTime)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 20.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Assigns the datetime value with the given dateTime object.

See also:

SQLDateTimeMBS.Set(value as Date)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 14.1 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Assigns the datetime value with the given date.

See also:

The items on this page are in the following plugins: MBS SQL Plugin.


The biggest plugin in space...