SQLDateTimeMBS methods

Online Documentation   -   Statistics   -   FAQ   -   Plugin Parts (All, Dependencies)   -   Class hierarchy

New in Version 22.2 22.3 22.4 22.5 23.0 23.1 23.2 23.3 23.4 23.5 24.0 24.1

The list of the   topics,   classes,   interfaces,   controls,   modules,   global methods by category,   global methods by name,   screenshots,   licenses   and   examples.

Platforms to show: All Mac Windows Linux Cross-Platform

Back to SQLDateTimeMBS class.

SQLDateTimeMBS.Constructor(DateTimeValue as DateTime)

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

See also:

SQLDateTimeMBS.Constructor(DateValue 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
Initializes the datetime value with the given date.

See also:

SQLDateTimeMBS.Constructor(Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 15.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Creates a new SQL Datetime with the given values.

See also:

SQLDateTimeMBS.Constructor(other as SQLDateTimeMBS)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Creates a copy of the SQL Date Time.
Example
dim d as new SQLDateTimeMBS(2008, 3, 4, 23, 10, 20)
dim e as new SQLDateTimeMBS(d)

MsgBox e.StringValue // shows "2008-03-04T23:10:20"

See also:

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.Constructor(value as Double)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Creates a new SQL date time value based on the double value.
Example
dim d as new SQLDateTimeMBS(2008, 3, 4, 23, 10, 20)
dim e as new SQLDateTimeMBS(d.DoubleValue+1) // clone with one day more

MsgBox e.StringValue // shows "2008-03-05T23:10:20"

See also:

SQLDateTimeMBS.Constructor(Year as Integer, Month as Integer, Day as Integer, Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0, TimeZone as String = "")

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Creates a new SQL Datetime with the given values.
Example
dim d as new SQLDateTimeMBS(2008, 3, 4, 23, 10, 20)

MsgBox d.StringValue // shows "2008-03-04T23:10:20"

See also:

SQLDateTimeMBS.Constructor(Year as Integer, Month as Integer, Day as Integer, Hour as Integer, Minute as Integer, Second as Integer, TimeZone as String)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 15.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Creates a new SQL Datetime with the given values.

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.


💬 Ask a question or report a problem