Call DateOf to convert a TDateTime value to a TDateTime value that includes only the date information (sets the time portion to 0, which means midnight).
Try: trunc(myTDateTimePicker.Date)
]]>If the date is correct in the database, the problem is the date/time picker returned value.
]]>myTSQLRecord.myDateTime := myTDateTimePicker.Date;
why in database i find the time?
]]>for TDateTimeField i mean a property of a TSQLRecord declared as TDateTime.
when i pass a Date value i find exactly the date i set (and only the date!)
when i pass a null Date (30 dec 1899) i find in database only the time (correctly dont save the date, but why the time???)
i hope that now the problem its clear.
thanks
Are you using the VCL wrapper?
How do you set "null" to a mORMot field (there is no such "null").
I do not understand your problem.
Perhaps it is an issue in the TClientDataSet itself.