Search found 2 matches
- 10.08.2007, 07:37
- Forum: MySQL
- Topic: Problems with Time and DateTime Fields
- Replies: 1
- Views: 1359
Update
Hi all, I found a solution to get the time and date correct out of the DB. I preformat the data ("startDateTime") and read it as a new field("startDateTime_formated"). Example-Query: with ZQuery do begin SQL.Clear; SQL.Add('SELECT *, date_format(startDateTime,"%d-%m-%Y %H:%i...
- 09.08.2007, 09:37
- Forum: MySQL
- Topic: Problems with Time and DateTime Fields
- Replies: 1
- Views: 1359
Problems with Time and DateTime Fields
Hi all, I'm working with Lazarus 0.9.20 Beta and Zeos lib 6.6.1Beta on a Debian System. Database server is a Mysql 5.0.32. Storing a date and a time in a DateTime field works ok. But if I read it with ZQuery1.fieldByName('startTime').asString I get the time minus one minute. Example: The date time i...