DateTime Data Type
Holds 64-bit (8-byte) date and time values in the range 1 January 0001 00:00:00–31 December 9999 23:59:59.
- Default value
- When you declare a variable of type
DateTimeand do not initialize it,, its value is
@0000-00-00@00:00:00, which ViviFire considers an invalid date.
- Type characters
DateTimehas no type character.
@ year / month / day
@ hours : minutes : seconds
@ year / month / day @ hours : minutes : seconds
The above named parts of a date or time must be decimal digits. Some additional rules follow.
- Divides the parts of a date.
Alternatively, you can use hyphens (
-) or periods (
- You can specify a fraction of a second by placing a decimal point (
.) between two sets of digits. The fractional part is limited to seven digits. Additional digits are ignored.
Shared methods and properties
DateTime.Bits As Int
- Returns 64.
DateTime.Day As Int
- Returns the current day of the month.
DateTime.Default As DateTime
- Returns the default value,
DateTime.Hour As Int
- Returns the current hour.
DateTime.Millisecond As Int
- Returns the current millisecond.
DateTime.Minute As Int
- Returns the current minute.
DateTime.Month As Int
- Returns the current month.
DateTime.Now As DateTime
- Returns the local date and time of the system.
DateTime.Parse(str As String, Optional #fmt As Format) As DateTime
- Tries to parse a string that shows as a date or time.
#fmtis not given or is
#Null, then it uses the format of the local culture. Or you can be explicit with
DateTime.Second As Int
- Returns the current second.
DateTime.UTCNow As DateTime
- Returns the current date and time in UTC.
DateTime.Year As Int
- Returns the current year.
ViviFire can convert between the
DateTime type and other types.
Some conversions are limited to one direction only.
Converting to DateTime
|integral types||When you add to or subtract from a DateTime a value such as 1, the integer represents 100 nanoseconds, (@0:0:0.0000001). Other values are a multiple of this.|
Converting from DateTime
|The short date format specified by the user's locale and the time either as a 12- or 24-hour format likewise. If you try to convert the default value to String, the result is TBD.|
|floating-point types||A value of 0.0 converts to @1899/12/30. Other whole numbers represent the number of days from this. Any values with fractional parts represent that fraction of a day (e.g., .5 represents 12 o'clock noon).|
Dim foo As DateTime foo = @2013/12/11@10:09:08