mORMot Open Source

arquivo59

Member

Registered: 2013-01-14

Posts: 24

Date and Time

Hello,

How can I handle fields of tipe only Date or only Time? I know there's TTimeLog / TModTime / TCreateTime. But can I use TDate and TTime?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Date and Time

Check the documentation - 1.18 SAD updated pdf.

There is no dedicated TDate/TTime handling.
TDateTime is handled, just as low level TDate/TTime, from the value point of view:
- If the time part is 0 (i.e. frac(value)=0), it will be stored as pure date.
- If the date part is 0 (i.e. trunc(value)=0),  it will be stored as pure time.
But it will depend on the underlying SQL engine, of course (some are not able to do this).