• Registered: 2014-05-29
  • Posts: 6

Topic: Date from SQL set to DateTimePicker

Hello

I need help, with set date from SQL to DateTimePicker. I have problem with date format. I tried different types of variables and his conversions.   It is possible to set DateTimePicker?

Thank you

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Date from SQL set to DateTimePicker

Hello,


example:

Form1.DateTimePicker1.Date := SQLDateTimeToDateTime ( SQLExecute('SELECT datefield FROM tablename') );
Dmitry.
  • Registered: 2014-05-29
  • Posts: 6

Re: Date from SQL set to DateTimePicker

Thank you. I forgot on SQLDateTimeToDateTime smile