Problem with current_time and firebird
lazarus / 16-Databases

----------------------------------------------------------------------
Ati · 2006-08-29 08:16

Hello,

i use a trigger to save date and time after i insert a record in my
db. If i  want to see all saved record´s the time-fields look like
"30.12.1899 9.05" ??? In the DB-Field the time is correctly. What´s
wrong??
Here is my Trigger-Code:
Code: [Select]CREATE TRIGGER REKLAMATIONEN_BI FOR REKLAMATIONEN
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.ID IS NULL) THEN
    NEW.ID = GEN_ID(GEN_REKLAMATIONEN_ID,1);
    new.rekdat=current_date;
    new.rekuhr=current_time;
END

----------------------------------------------------------------------
Ati · 2006-08-29 08:51

I have solved the problem. In the Item-Properties is a field
"DisplayFormat". There must be "hh:mm" insert and that´s all.