synopse / mORMot

Synopse mORMot 1 ORM/SOA/MVC framework - Please upgrade to mORMot 2 !
https://synopse.info
789 stars 325 forks source link

fixed conversion time part of date in TOracleDate record problem #318

Closed ASiwon closed 4 years ago

ASiwon commented 4 years ago

This change fixes the bug in conversion time part of datetime values which contains only date. This bug causes writing incorrect values into field values in Oracle using batch mode. In normal mode this bug not occurs because to set date values into the query it is used timestamp structure instead of date structure. The value in the table fields look like correct date but it is not equal date value. This causes it is impossible to find saved record by date value which is very frustrating to the user. According to informations on http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28395/oci03typ.htm#sthref389 for date only value each element of time part should have 1 value in SQLT_DAT kind structure.