Platforms to show: All Mac Windows Linux Cross-Platform

Back to SQLIntervalMBS class.

SQLIntervalMBS.Days as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The days in this interval.

(Read only property)

SQLIntervalMBS.DoubleValue as Double

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The value of this interval.
Example 
dim n as new SQLIntervalMBS(1,2,3,4)

MsgBox str(n.DoubleValue) // shows "1.085463" for 1 day, 2 hours, 3 minutes and 4 seconds

(Read only property)

SQLIntervalMBS.Fraction as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 15.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The fraction of a second in nano seconds.

Range 0..999999999.
(Read only property)

SQLIntervalMBS.Hours as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The hours value.

(Read only property)

SQLIntervalMBS.Minutes as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The minutes value.

(Read only property)

SQLIntervalMBS.Seconds as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The seconds value.

(Read only property)

SQLIntervalMBS.StringValue as string

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The interval as a string.
Example 
dim n as new SQLIntervalMBS(5)

MsgBox n.StringValue // shows "120:00:00" for 120 hours

(Read only property)

SQLIntervalMBS.TotalDays as Double

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The total days value.
Example 
dim n as new SQLIntervalMBS(1,2,3,4)

MsgBox str(n.TotalDays) // shows "1"

(Read only property)

SQLIntervalMBS.TotalHours as Double

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The total hours value.
Example 
dim n as new SQLIntervalMBS(1,2,3,4)

MsgBox str(n.TotalHours) // shows "26"

(Read only property)

SQLIntervalMBS.TotalMinutes as Double

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The total minutes value.
Example 
dim n as new SQLIntervalMBS(1,2,3,4)

MsgBox str(n.TotalMinutes) // shows "1563"

(Read only property)

SQLIntervalMBS.TotalSeconds as Double

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The total seconds value.

dim n as new SQLIntervalMBS(1,2,3,4)

MsgBox str(n.GetTotalSeconds) // shows "93784"
(Read only property)

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


The biggest plugin in space...