Platforms to show: All Mac Windows Linux Cross-Platform
SQLDateTimeMBS class
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
class | SQL | MBS SQL Plugin | 9.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Example:
dim d as new SQLDateTimeMBS(2008, 3, 4, 23, 10, 20)
MsgBox d.StringValue // shows "2008-03-04T23:10:20"
see also
https://www.sqlapi.com/ApiDoc/class_s_a_date_time.html
- 16 properties
- property DateTimeValue as DateTime
- property DateValue as Date
- property Day as Integer
- property DayOfWeek as Integer
- property DayOfYear as Integer
- property DoubleValue as Double
- property Fraction as Integer
- property hasDate as Boolean
- property hasTime as Boolean
- property Hour as Integer
- property Minute as Integer
- property Month as Integer
- property Second as Integer
- Property StringValue as string
- property TimeZone as String
- property Year as Integer
- 9 methods
- method Constructor(Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0)
- method Constructor(other as SQLDateTimeMBS)
- method Constructor(value as Date)
- method Constructor(value as DateTime)
- method Constructor(value as Double)
- method 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 = "")
- method Constructor(Year as Integer, Month as Integer, Day as Integer, Hour as Integer, Minute as Integer, Second as Integer, TimeZone as String)
- method Set(value as Date)
- method Set(value as DateTime)
This class has no sub classes.
Some methods using this class:
- SQLValueMBS.setAsDateTime(value as SQLDateTimeMBS)
- SQLValueReadMBS.asDateTime as SQLDateTimeMBS
Blog Entries
- MBS Xojo Plugins, version 20.4pr8
- MBS Xojo Plugins, version 19.6pr1
- MonkeyBread Software Releases the MBS Xojo / Real Studio plug-ins in version 14.1
- MBS Xojo / Real Studio Plugins, version 14.1pr1
The items on this page are in the following plugins: MBS SQL Plugin.
SQLDataProviderMBS - SQLErrorExceptionMBS

Links
MBS FileMaker Plugins