질문하기

kmartin's profile - activity

2019-05-19 18:47:45 +0200 받은 배지  정리의 달인
2018-03-06 15:12:31 +0200 받은 배지  유명한 질문 (source)
2017-03-01 01:27:45 +0200 받은 배지  학생 (source)
2017-03-01 00:49:51 +0200 받은 배지  주목할 만한 질문 (source)
2017-02-28 04:43:58 +0200 받은 배지  학자 (source)
2017-02-27 16:35:56 +0200 받은 배지  인기있는 질문 (source)
2017-02-27 09:23:44 +0200 받은 배지  편집자 (source)
2017-02-27 07:13:49 +0200 질문하였습니다 TIMESTAMP data type auto-fill problem what am I missing?

This seams like a very useful tool. Have a table with a column of the data type TIMESTAMP, and auto fill that field in a form with the unique timestamp of date+time. I'm having a bad time with this little gremlin. Much is due to my newness to LibreOffice. I have searched the web: found https://www.youtube.com/watch?v=OBtxu...
and this forums: https://ask.libreoffice.org/en/questi... .

The tools > SQL > command to execute >

//fill in transaction timestamp field

ALTER TABLE "DailySales" ALTER COLUMN "transaction" SET DEFAULT CURRENT_TIMESTAMP

executes but I get no auto fill in the form. In fact I can not save the form until I enter something in the field and then the data in the table is bad, e.g. 1800-01-01 01:03:00 .

I am using Version: 5.2.5.1

So here I am... and thanks in advance

martin