SQLDateTimeMBS.DateTimeValue as DateTime

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	20.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Queries the value of this datetime object as a date object.

(Read only property)

SQLDateTimeMBS.DateValue as Date

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	14.1	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Queries the value of this datetime object as a date object.

(Read only property)

SQLDateTimeMBS.Day as Integer

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

Returns the day this SADateTime object represents (1 – 31).

(Read only property)

SQLDateTimeMBS.DayOfWeek as Integer

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

Returns the day of the week this SADateTime object represents (Sunday = 1).

(Read only property)

SQLDateTimeMBS.DayOfYear as Integer

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

Returns the day of the year this SADateTime object represents (Jan 1 = 1).

(Read only property)

SQLDateTimeMBS.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 double value of this date/time.

Use these operators to get current date/time value using standard double representation. Days are represented by whole number increments starting with 30 December 1899, midnight as time zero. Hour values are expressed as the absolute value of the fractional part of the number.

Date and time	Representation
30 December 1899, midnight	0.00
1 January 1900, midnight	2.00
4 January 1900, midnight	5.00
4 January 1900, 6 A.M.	5.25
4 January 1900, noon	5.50
4 January 1900, 9 P.M.	5.875

(Read only property)

SQLDateTimeMBS.Fraction as Integer

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

Returns the value of the fraction of second (0 to 999,999,999) this SQLDateTime object represents.

The value of the fraction field is the number of billionths of a second and ranges from 0 through 999,999,999 (1 less than 1 billion). For example, the value of the fraction field for a half-second is 500,000,000, for a thousandth of a second (one millisecond) is 1,000,000, for a millionth of a second (one microsecond) is 1,000, and for a billionth of a second (one nanosecond) is 1.
(Read only property)

SQLDateTimeMBS.hasDate as Boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	20.0	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Whether this date & time object contains a date.

(Read only property)

SQLDateTimeMBS.hasTime as Boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	20.0	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Whether this date & time object contains a time.

(Read only property)

SQLDateTimeMBS.Hour as Integer

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

Returns the hour this SADateTime object represents (0 – 23).

(Read only property)

SQLDateTimeMBS.Minute as Integer

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

Returns the minute this SADateTime object represents (0 – 59).

(Read only property)

SQLDateTimeMBS.Month as Integer

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

Returns the month this SADateTime object represents (1 – 12).

(Read only property)

SQLDateTimeMBS.Second as Integer

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

Returns the second this SADateTime object represents (0 – 59).

(Read only property)

SQLDateTimeMBS.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 string value for this date/time.

(Read only property)

SQLDateTimeMBS.TimeZone as String

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	15.1	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

The time zone.

Should be in format "00:00" and should be supported for Oracle and Postgres.
(Read and Write property)

SQLDateTimeMBS.Year as Integer

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

Returns the year this SADateTime object represents.

(Read only property)