Date of the default Settings-CodePudding

In database table I create one for fill in the date, I hope that date will be automatically defaults to the current date, how to implement?

CodePudding user response:

If it is in the PB of DW, in the initial fill in today, is automatically fill in the date on the day of new,

CodePudding user response:

Methods can only use single upstairs, if it is a client connection server, is the local time, not the server time,
The original poster with the database?
Create a table, can give column specifies the default value of ah, here is oracle's

 
The create table table name 
(
Id number not null, 
Fill in the date date default sysdate 
);

CodePudding user response:

[b]

refer to the second floor NorthStar21 response:

method can only use single upstairs, if it is a client connection server, is the local time, not the server time,
The original poster with the database?
Create a table, can give column specifies the default value of ah, here is oracle's
 
The create table table name 
(
Id number not null, 
Fill in the date date default sysdate 
); 

I am using ASA database, when creating a table, I set the default values for the current datetime, but cannot achieve actual operation

CodePudding user response:

reference u012527514 reply: 3/f

[b]
Quote: refer to the second floor NorthStar21 response:

Methods can only use single upstairs, if it is a client connection server, is the local time, not the server time,
The original poster with the database?
Create a table, can give column specifies the default value of ah, here is oracle's

The create table table name
(
Id number not null,
Fill in the date date default sysdate
);

I am using ASA database, when creating a table, I set the default values for the current datetime, but actual operation cannot achieve

If set to a default value, it is recommended that you build the data window does not choose this field, and then you try to save the data,

CodePudding user response:

reference 4 floor lzp_lrp response:

Quote: reference u012527514 reply: 3/f
[b]
Quote: refer to the second floor NorthStar21 response:

Methods can only use single upstairs, if it is a client connection server, is the local time, not the server time,
The original poster with the database?
Create a table, can give column specifies the default value of ah, here is oracle's

The create table table name
(
Id number not null,
Fill in the date date default sysdate
);

I am using ASA database, when creating a table, I set the default values for the current datetime, but actual operation cannot achieve
If set to a default value, it is recommended that you build the data window does not choose this field, and then you try to save the data,

+ + + database design with a default value, don't give value in the program code,

CodePudding user response:

reference u012527514 reply: 3/f

what I use is ASA database, when creating a table, I set the default values for the current datetime, but actual operation cannot achieve

Your dataobject don't select this list,

CodePudding user response:

Or write a server time function call unity