Any existing fragments with out-of-date column statistics will also be rebuilt at this time.
任何列统计过时的现有片段也将在此时重新构建。
DBDATE: the date column values in the external data file are in the format specified by this DBDATE.
DBDATE:外部数据文件中的日期列值采用由这个DBDATE指定的格式。
The create date column specifies the date when the database was created, with YYYY-MM-DD being the format.
Createdate列是创建数据库的日期,采用YYYY- MM - dd格式。
For example, a sales table fragmented by transaction date column such that new rows are added each month to store current month sales data.
例如,按照事务日期列分段的销售表,每个月都将添加新的行来存储当月的销售数据。
A new column indicates the last modification date.
一个新列会指示最后的编辑日期。
Defining the local column as DATE is convenient because it allows predicates that involve DATE literals, but does not require casting functions (which tend to impact performance).
将本地列定义为DATE类型比较方便,因为这样可以允许涉及DATE文字但是不需要覆盖函数(对性能有影响)的谓词。
The next two lines retrieve the article date (from the POSTED column) and convert it to RFC 3339 format using the aforementioned function.
接下来的两行代码检索文章日期(从posted列)并使用之前提到的函数将其转变为RFC 3339格式。
Let's add one more column for the date the item was done.
让我们再添加一个列,表示完成该事项的日期。
The second column contains the publish date of the announcement.
第二列包含公告的发布日期。
Recall that the input string contains a full timestamp with date and time information, and you want to populate the TIMECHANGED column in the DB2 target table with only a time value.
记住,输入字符串包含一个带有日期和时间信息的完整时间戳,您希望仅使用一个时间值填充db 2目标表中的timechanged列。
The INFO column contains employee information such as name, designation, salary, date of joining, department and contact details represented in an XML document.
INFO列包含雇员信息,比如在XML文档中列出的姓名、职责、薪水、入职日期、部门和联系方式。
Finally, the return clause returns the new node representing the scheduled termination date so that DB2 will update data in the DOCUMENT column with the modified data.
最后,return子句返回代表预定终止日期的新节点,所以DB 2将用修改后的数据更新document列中的数据。
Finally, the posted column is a DATETIME column that stores the date that the article was posted on the Web site.
最后,posted列是一个datetime列,存储了文章发布到网站的日期。
When you select this option, a database column defined with a Date data type is defined in the type tree as a character text string.
如果选择这个选项,定义为Date数据类型的数据库列在类型树中定义为一个字符文本字符串。
When the view opens in Domino Designer, delete all columns except Date and Topic, and add a categorized column at the far left, as shown in figure 9.
当视图在DominoDesigner 中打开后,删除Date和Topic 之外的全部列,并在最左侧添加一个用于分类的列,如图 9 所示。
For example, you can now change a column defined with a data type of INTEGER to have a data type of VARCHAR, or you can change a data type of TIMESTAMP to DATE.
例如,现在可以修改一个数据类型为INTEGER的列,从而拥有一个VARCHAR数据类型,或者将数据类型从TIMESTAMP修改为DATE。
A typical design is an MDC dimension for a column representing date plus dimensions on 0 to 3 other columns such as region and product_type.
典型的设计是用一个表示日期的列作为一个mdc维,再加上0到3个其他列作为其他维,例如region和product _ type。
In the example in Figure 2, the application identifies the XML schema used for XML data from another column value (creation date in this example).
在图2中的示例中,应用程序从另一个列值(本例中为创建日期)识别用于XML数据的XMLschema。
DurationLabel: Identifies the duration that is associated with the Constant value specified if the partitioning key column has been assigned a date, time, or time stamp data type.
DurationLabel:如果分区键列的数据类型是日期、时间或时间戳,这个参数指定与Constan t值相关的时间单位。
This conversion of the date can done using concatenate excel function along with column references.
日期转换可以使用连接的Excel功能以及列引用来完成。
The order by posted desc clause forces the query to return rows in descending order by the date in the posted column (which is the date that the article was posted on the Web site).
orderbyposteddesc子句强迫此查询按posted列中的日期(即文章发布到Web站点的日期)的降序返回行。
The Last Filled column informs the user of the date and time when each logical log was used for the last time.
LastFilled列显示最后一次使用每个逻辑日志的日期和时间。
Time/date sensitive formulas (selection or column formulas)
时间/日期敏感的公式(选择公式或列公式)
For example, for family info and a member date, the column key is info:date.
例如,对于系列info和成员date,列键为 info:date。
For example, you can set whether to show or hide column headings, date, filter table, and so on.
例如,你可以选择是否显示列表表格的标题栏、创建日期、过滤器等等。
But if a column of type date is only used to store the date of birth of employees, you can map it to the DB2 date type.
但是,如果类型为DATE的一个列只用于存储雇员的生日,那么就可以将它映射为DB 2 date类型。
In the example shown in Table 2, the first column holds the date on which the change shown in each row is made.
表2显示的这个例子中,第一列中记录了每一行所显示的变化日期。
Finally, add a third column to display the modification date. The script here is.
最后,再添加一列显示修改日期。
The expression date("XMLTABLE_08"."datechanged") defines the DATECHANGED result column, as shown in Figure 11.
表达式date("XMLTABLE_08"."datechanged")定义DATECHANGED结果列,如图 11 所示。
The expression date("XMLTABLE_08"."datechanged") defines the DATECHANGED result column, as shown in Figure 11.
表达式date("XMLTABLE_08"."datechanged")定义DATECHANGED结果列,如图 11 所示。
应用推荐