Search found 2 matches

by Pedali
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...
by Pedali
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...