[Solved] Create field that automatic stamps Current Date?

[DreamerArgentino]

Hello everybody!!

Can I create a field that automatically stamps the current date without code?

I have looked for information about it, and I see that code is used. There is no sensible way to do it? I have seen the CURDATE () function, but I would not know how to use it to be inserted automatically in a Date field of a table, every time I create a new record.

Thank you!
Dreamer.-

[UnklDonald418]

To add a Timestamp column that

automatically stamps the current date without code

edit the following SQL command with your table and column/field names

Code: Select all

ALTER TABLE "YourTableName" ADD COLUMN "YourColumnName" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP;

and then got to Tools->SQL and execute the command.
You should also select View->Refresh tables to make sure you can see the change to your table.

[DreamerArgentino]

To add a Timestamp column that

automatically stamps the current date without code

edit the following SQL command with your table and column/field names

Code: Select all

ALTER TABLE "YourTableName" ADD COLUMN "YourColumnName" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP;

and then got to Tools->SQL and execute the command.
You should also select View->Refresh tables to make sure you can see the change to your table.

It works wonders! but, I ask, will it be possible to generate two separate fields in the same way? One Date and another Time? Thanks!

[UnklDonald418]

You can add separate Date and Time controls to a form using the TimeStamp column as the Data source.
One way to separate them in a query use

Code: Select all

TO_CHAR("YourTimeStampColumnName", 'MM/DD/YYYY') AS "Date",
TO_CHAR("YourTimeStampColumnName", 'HH24:MI:SS:FF') AS "Time"

If you don't need all the time accuracy you could change the time formatting to 'HH24:MI' or maybe 'HH12:MI'

[Sliderule]

It works wonders! but, I ask, will it be possible to generate two separate fields in the same way? One Date and another Time? Thanks!

Code: Select all

-- Code below will add a DATE column and a DEFAULT DATE . . . change both table and column name to your needs
ALTER TABLE "YourTableName" ADD COLUMN "YourDateColumnName" DATE DEFAULT CURRENT_DATE;


-- Code below will add a TIME column and a DEFAULT TIME . . . change both table and column name to your needs
ALTER TABLE "YourTableName" ADD COLUMN "YourTimeColumnName" TIME DEFAULT CURRENT_TIME;


-- Code below will add a TIMESTAMP column and a DEFAULT TIMESTAMP . . . change both table and column name to your needs
ALTER TABLE "YourTableName" ADD COLUMN "YourTimeStampColumnName" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP;

Sliderule

[DreamerArgentino]

It works wonders! but, I ask, will it be possible to generate two separate fields in the same way? One Date and another Time? Thanks!

Code: Select all

-- Code below will add a DATE column and a DEFAULT DATE . . . change both table and column name to your needs
ALTER TABLE "YourTableName" ADD COLUMN "YourDateColumnName" DATE DEFAULT CURRENT_DATE;


-- Code below will add a TIME column and a DEFAULT TIME . . . change both table and column name to your needs
ALTER TABLE "YourTableName" ADD COLUMN "YourTimeColumnName" TIME DEFAULT CURRENT_TIME;


-- Code below will add a TIMESTAMP column and a DEFAULT TIMESTAMP . . . change both table and column name to your needs
ALTER TABLE "YourTableName" ADD COLUMN "YourTimeStampColumnName" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP;

Sliderule

Excellent!! Thank you very much to all!!!
Greetings!
DreamerArg.-