Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

SQLDateTimeMBS.DateValue as Date
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 14.1 Yes Yes Yes Yes No
Function: Queries the value of this datetime object as a date object.
Notes: (Read only property)

Feedback, Comments & Corrections

SQLDateTimeMBS.Day as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns the day this SADateTime object represents (1 – 31).
Notes: (Read only property)

Feedback, Comments & Corrections

SQLDateTimeMBS.DayOfWeek as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns the day of the week this SADateTime object represents (Sunday = 1).
Notes: (Read only property)

Feedback, Comments & Corrections

SQLDateTimeMBS.DayOfYear as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns the day of the year this SADateTime object represents (Jan 1 = 1).
Notes: (Read only property)

Feedback, Comments & Corrections

SQLDateTimeMBS.DoubleValue as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The double value of this date/time.
Notes:
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 timeRepresentation
30 December 1899, midnight0.00
1 January 1900, midnight2.00
4 January 1900, midnight5.00
4 January 1900, 6 A.M.5.25
4 January 1900, noon5.50
4 January 1900, 9 P.M.5.875
(Read only property)

Feedback, Comments & Corrections

SQLDateTimeMBS.Fraction as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns the value of the fraction of second (0 to 999,999,999) this SQLDateTime object represents.
Notes:

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)

Feedback, Comments & Corrections

SQLDateTimeMBS.Hour as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns the hour this SADateTime object represents (0 – 23).
Notes: (Read only property)

Feedback, Comments & Corrections

SQLDateTimeMBS.Minute as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns the minute this SADateTime object represents (0 – 59).
Notes: (Read only property)

Feedback, Comments & Corrections

SQLDateTimeMBS.Month as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns the month this SADateTime object represents (1 – 12).
Notes: (Read only property)

Feedback, Comments & Corrections

SQLDateTimeMBS.Second as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns the second this SADateTime object represents (0 – 59).
Notes: (Read only property)

Feedback, Comments & Corrections

SQLDateTimeMBS.StringValue as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
Property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The string value for this date/time.
Notes: (Read only property)

Feedback, Comments & Corrections

SQLDateTimeMBS.TimeZone as String
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 15.1 Yes Yes Yes Yes No
Function: The time zone.
Notes:
Should be in format "00:00" and should be supported for Oracle and Postgres.
(Read and Write property)

Feedback, Comments & Corrections

SQLDateTimeMBS.Year as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns the year this SADateTime object represents.
Notes: (Read only property)

Feedback, Comments & Corrections

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




Links
MBS Xojo Plugins