Hello All,
I am designing a software with Delphi 7 and I have forms on it.
My forms are connected to my MSSQL Server 2005 tables over AdoConnections and AdoTables.
On my form I have DBedits which are directly connected to a table in my database through DataSource.
A ss of my From is below;

As you can see I have DbDateTimepickers attachted on my form.What I am trying to do is;
A ss of what I want ;

I dont want to use Dbdatetimepickers.I want to seperate the date, the time and the schedule in to 3 parts.First section is to fillng the DATE
second is the Schedule from the Schedule icon and the 3rd part is the time section.
My questions:

1. How could I separete the datetime value coming from my database in to 3 parts?
2. When the user fills the required values into these 3 sections, when the user clicks on Ok/SAVE. How can I get those 3 values,combine and save to my database?

I will appriciate your interest of helping me..
Thanks.

Can anyone help?

You will find that the number of delphi users nowadays is VERY low, so don't expect too much... I used to use it myself, but that was in the windows 95 era (10 years ago). It's been several years since I encountered anyone still using it too.


Delphi should have standard functions to get just the date, or just the time from a standard DateTime format.



Same answer as the previous really. Delphi should have standard functions to generate standard DateTime format from separate date and time values. Then use that to update the database.

There are people using Delphi, but you need to work to find them, as was said. I use it, but purely from a hobbyist standpoint (I learned on Pascal, and Delphi was the easiest transition that fitted my budget and my tolerance level).

As for your problem, I'm not well-versed in the database end of what you're doing with Delphi. But if I understand your problem right (and I'm not sure), you're pulling TDateTime from your database and you would rather have it show in a TEdit style structure instead of the DBDateTimePicker? As was stated, there are several functions in SysUtils that should make that transition for you easily.