CODEWITHSUNDEEP
delphidbgridtdbgriddelphi-10.2-tokyo
user8660795
user8660795

Reputation:

My Time Field in my DBGrid is showing the date and time instead of time only - delphi

I have a field in my database called 'Times', it's a date/time format and its format is set to 'short time'. In my database the date does not show, nor is it being add to the database as I know. It is only the time value. My DBGrid shows the time field with the time value and the date '12/30/1899'. How do I get rid of the date in my time field.

Here is the code I used to submit to the database. Get time value:

bookingtimes:= timeof(dttime.Time);

Submit to Database:

 tblbooking.FieldByName('Times').AsDateTime:=bookingtimes;

Example of DBGrid 'Times' column output:

12/30/1899 7:02:01AM

Upvotes: 0

Views: 3968

Answers (1)

Ilyes
Ilyes

Reputation: 14928

If I understand what you mean this will work for you, just follow this steps:

  • This is your issue:

  • Double click on your table, and select Times field:

  • After you click on your field, go to the Object Inspector and find DisplayFormat property:

  • Write the format, in your case hh:mm:ss:

  • Now let's see the result:

That's it.

Upvotes: 5

Related Questions