Delphi / MySql: timestamp in components that support DB

Question

Delphi does not use * nix timestamps. In other applications, I converted to * nix before saving to MySql and reversed it when I checked out.

Now I would like to first try using components that support DB. How will this work on tiemstamps? Should I (can I) store in Delphi tiemstamp format? Or do I convert shoudl to * nix before saving?

Answer 1

For normal use, you do not need to do anything.

I have used Delphi / MySQL for many years, and all the data access components that I used (dbexpress / zeros / MyDAC) automatically convert. In case I need to manually specify the timestamp value, I just provide the text format ("yyyy / mm / dd hh: nn: ss")