Patrick wrote (in response):
>No, that is the ANSI SQL standard for date formats. Database Desktop for
>example uses this format in SQL queries even though it will display the
>results in the local format. Using parameterised dates (my current project
>builds the SQL in code but puts in parameters and assigns the TParams)
>simply lets you use a TDateTime.
>Incidentally the TDateTimePicker declares both its Time and Date properties
>to be in effect TDateTime which suggests maybe there is just one internal
>TDateTime attribute that hold both and formats the Date and Time published
>properties.
Thanks for the tip on the ANSI SQL standard - guess we know where the 'A'
comes from in ANSI.
The problem is in the TDateTimePicker or more correctly in the setting
(default) of the Time property.
Time gets set to the time you drop it on the form not to zero. Set it to
zero and guess what??
Regards,
Mike
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
