Platforms to show: All Mac Windows Linux Cross-Platform

SQLDateTimeMBS class

dim d as new SQLDateTimeMBS(2008, 3, 4, 23, 10, 20)

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

• 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
• 10 methods
  • method Constructor(DateTimeValue as DateTime)
  • method Constructor(DateValue as Date)
  • method Constructor(Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0)
  • method Constructor(other as SQLDateTimeMBS)
  • method Constructor(StringValue as String)
  • 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(DateTimeValue as DateTime)
  • method Set(value as Date)

This class has no sub classes.

Some methods using this class:

• SQLValueMBS.setAsDateTime(value as SQLDateTimeMBS)
• SQLValueReadMBS.asDateTime as SQLDateTimeMBS

Some examples using this class:

• /SQL/SQL Unit Tests

Blog Entries

• MBS Xojo Plugins, version 21.2pr3
• 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

Xojo Developer Magazine

• 19.4, page 53: Maps—Part 10, Mapping GPS data with the MapKitMBS plugin by Markus Winter

Release notes

• Version 21.2
  • Added constructor for string to SQLDateTimeMBS class.
• Version 20.4
  • Applied SQLAPI patch for SADateTime, e.g. our SQLDateTimeMBS class.
• Version 20.0
  • Added hasDate and hasTime properties to SQLDateTimeMBS class.

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

SQLDataProviderMBS   -   SQLErrorExceptionMBS