Wednesday, September 15, 2010

Re: Time DBTIMESTAMP

 http://msdn.microsoft.com/en-us/library/c3zzz087(v=VS.80).aspx
 Function for getting the DBTIMESTAMP.
 bool GetAsDBTIMESTAMP(       DBTIMESTAMP& dbts ) const throw();

On Wed, Sep 15, 2010 at 9:41 AM, Stan Hughes <hughes.stan@gmail.com> wrote:

The fraction time is from 0 to 999,999,999.

Not really sure what good this does since you can only get it for the current time and any translation of time rounds to the nearest second.

DBTIMESTAMP

The DBTIMESTAMP structure typedef is defined as follows:

 typedef struct tagDBTIMESTAMP {     SHORT  year;     USHORT month;     USHORT day;     USHORT hour;     USHORT minute;     USHORT second;     ULONG  fraction } DBTIMESTAMP; 

Members

year
The year (0 to 9999) is measured from 0 A.D.
month
The month ranges from 1 to 12 representing January through December.
day
The day ranges from 1 to a maximum of 31, depending on the number of days in the month.
hour
The hour ranges from 0 to 23.
minute
The minute ranges from 0 to 59.
second
The second ranges from 0 to 59.
fraction
The fraction represents billionths of a second ranging from 0 to 999,999,999.

No comments: