SQLDateTimeMBS methods
Online Documentation - Statistics - FAQ - Plugin Parts (All , Dependencies ) - Class hierarchy
New in Version
22.2
22.3
22.4
22.5
23.0
23.1
23.2
23.3
23.4
23.5
24.0
24.1
The list of the topics ,
classes ,
interfaces ,
controls ,
modules ,
global methods by category ,
global methods by name ,
screenshots ,
licenses
and examples .
Platforms to show: All Mac Windows Linux Cross-Platform
Back to SQLDateTimeMBS class.
SQLDateTimeMBS .Constructor(DateTimeValue as DateTime)
Initializes the datetime value with the given DateTime object.
See also:
Constructor(DateValue as Date)
Constructor(Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0)
Constructor(other as SQLDateTimeMBS)
Constructor(StringValue as String)
Constructor(value as Double)
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 = "")
Constructor(Year as Integer, Month as Integer, Day as Integer, Hour as Integer, Minute as Integer, Second as Integer, TimeZone as String)
SQLDateTimeMBS .Constructor(DateValue as Date)
Initializes the datetime value with the given date.
See also:
Constructor(DateTimeValue as DateTime)
Constructor(Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0)
Constructor(other as SQLDateTimeMBS)
Constructor(StringValue as String)
Constructor(value as Double)
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 = "")
Constructor(Year as Integer, Month as Integer, Day as Integer, Hour as Integer, Minute as Integer, Second as Integer, TimeZone as String)
SQLDateTimeMBS .Constructor(Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0)
Creates a new SQL Datetime with the given values.
See also:
Constructor(DateTimeValue as DateTime)
Constructor(DateValue as Date)
Constructor(other as SQLDateTimeMBS)
Constructor(StringValue as String)
Constructor(value as Double)
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 = "")
Constructor(Year as Integer, Month as Integer, Day as Integer, Hour as Integer, Minute as Integer, Second as Integer, TimeZone as String)
SQLDateTimeMBS .Constructor(other as SQLDateTimeMBS )
Creates a copy of the SQL Date Time.
Example
dim d as new SQLDateTimeMBS (2008 , 3 , 4 , 23 , 10 , 20 )dim e as new SQLDateTimeMBS (d) MsgBox e.StringValue // shows "2008-03-04T23:10:20"
See also:
Constructor(DateTimeValue as DateTime)
Constructor(DateValue as Date)
Constructor(Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0)
Constructor(StringValue as String)
Constructor(value as Double)
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 = "")
Constructor(Year as Integer, Month as Integer, Day as Integer, Hour as Integer, Minute as Integer, Second as Integer, TimeZone as String)
SQLDateTimeMBS .Constructor(StringValue as String)
Initialized a date time value from a string.
Example
Dim d As New SQLDateTimeMBS ("2021-04-12T18:46:16.242" ) msgbox d.StringValueDim d2 As New SQLDateTimeMBS ("now" ) MsgBox d2.StringValue
You can pass "now" for current time, a string containing a double value for seconds since epoche or a string formatted with SQL datetime. Either with T or space as separator. If fraction is given, it should be 3 digits for milliseconds.
See also:
Constructor(DateTimeValue as DateTime)
Constructor(DateValue as Date)
Constructor(Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0)
Constructor(other as SQLDateTimeMBS)
Constructor(value as Double)
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 = "")
Constructor(Year as Integer, Month as Integer, Day as Integer, Hour as Integer, Minute as Integer, Second as Integer, TimeZone as String)
SQLDateTimeMBS .Constructor(value as Double)
Creates a new SQL date time value based on the double value.
Example
dim d as new SQLDateTimeMBS (2008 , 3 , 4 , 23 , 10 , 20 )dim e as new SQLDateTimeMBS (d.DoubleValue+1 ) // clone with one day more MsgBox e.StringValue // shows "2008-03-05T23:10:20"
See also:
Constructor(DateTimeValue as DateTime)
Constructor(DateValue as Date)
Constructor(Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0)
Constructor(other as SQLDateTimeMBS)
Constructor(StringValue as String)
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 = "")
Constructor(Year as Integer, Month as Integer, Day as Integer, Hour as Integer, Minute as Integer, Second as Integer, TimeZone as String)
SQLDateTimeMBS .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 = "")
Creates a new SQL Datetime with the given values.
Example
dim d as new SQLDateTimeMBS (2008 , 3 , 4 , 23 , 10 , 20 ) MsgBox d.StringValue // shows "2008-03-04T23:10:20"
See also:
SQLDateTimeMBS .Constructor(Year as Integer, Month as Integer, Day as Integer, Hour as Integer, Minute as Integer, Second as Integer, TimeZone as String)
Creates a new SQL Datetime with the given values.
See also:
Constructor(DateTimeValue as DateTime)
Constructor(DateValue as Date)
Constructor(Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0)
Constructor(other as SQLDateTimeMBS)
Constructor(StringValue as String)
Constructor(value as Double)
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 = "")
The items on this page are in the following plugins: MBS SQL Plugin .