how to set a column to fetch the date now?
Like this?

CREATE TABLE "DATENOW"
(
  ID Char(8) NOT NULL,
  "Start_Date" Char(10),
  "Client_Name" Varchar(30),
  BALANCE Integer,
  Now_Column TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT PK_datenow PRIMARY KEY (ID)
);


If you INSERT into the table, and ommit a value for Now_Column (IE: it's NULL), the current timestamp will be used instead.

Also, never use CHAR/VARCHAR datatypes to hold dates (which I suspect you are trying to do with your Start_Date column) - use proper date datatypes.

Untested, by the way - this is from the documentation.