Recent

Author Topic: Problem with current_time and firebird  (Read 3306 times)

Ati

  • New Member
  • *
  • Posts: 41
Problem with current_time and firebird
« on: August 29, 2006, 10:16:52 am »
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

  • New Member
  • *
  • Posts: 41
RE: Problem with current_time and firebird
« Reply #1 on: August 29, 2006, 10:51:17 am »
I have solved the problem. In the Item-Properties is a field "DisplayFormat". There must be "hh:mm" insert and that´s all.