Data.SqlTimSt.TSQLTimeStampOffset
Delphi
TSQLTimeStampOffset = record
Year: Word;
Month: Word;
Day: Word;
Hour: Word;
Minute: Word;
Second: Word;
Fractions: Cardinal;
TimeZoneHour: SmallInt;
TimeZoneMinute: SmallInt;
end;
C++
struct DECLSPEC_DRECORD TSQLTimeStampOffset
{
public:
System::Word Year;
System::Word Month;
System::Word Day;
System::Word Hour;
System::Word Minute;
System::Word Second;
unsigned Fractions;
short TimeZoneHour;
short TimeZoneMinute;
};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
record struct |
public | Data.SqlTimSt.pas Data.SqlTimSt.hpp |
Data.SqlTimSt | Data.SqlTimSt |
Description
TSQLTimeStampOffset represents time and date values with a high degree of accuracy, relative to the Coordinated Universal Time (UTC).
The dbExpress database drivers use TSQLTimeStampOffset when working with date and time information.
Year specifies a year from 1 through 9999. Month specifies a month from 1 through 12. Day specifies a day of the month, from 1 through 28, 29, 30, or 31, depending on the Month value. Hour specifies the hour from 0 through 23. Minute and Second can range from 0 through 59. Fractions specifies milliseconds from 0 through 999.
The fields TimeZoneHour and TimeZoneMinute represent the hour and minute relative to the Coordinated Universal Time (UTC). TimeZoneHour must be in the range from -12 through 13, while TimeZoneMinute must be in the range from 0 through 59.
You can create a Variant that represents a TSQLTimeStampOffset value using the VarSQLTimeStampCreate function. The easiest way to manipulate TSQLTimeStampOffset values is to create such a Variant and use the built-in operators provided by the Variant type.