PostgreSQL 16.1 Documentationdate_trunc is conceptually similar to the trunc function for numbers. date_trunc(field, source [, time_zone ]) source is a value expression of type timestamp, timestamp with time zone, or interval. (Values By default, truncation is done with respect to the current TimeZone setting, but the optional time_zone argument can be provided to specify a different time zone. The time zone name can be specified in are date_add(), date_subtract(), and generate_series(). • Change date_trunc(unit, timestamptz, time_zone) to be an immutable function (Prze- myslaw Sztoch) This allows the creation of expression indexes0 码力 | 3133 页 | 14.10 MB | 1 年前3
PostgreSQL 16.1 Documentationsimilar to the trunc function for numbers. 285 Functions and Operators date_trunc(field, source [, time_zone ]) source is a value expression of type timestamp, timestamp with time zone, or inter- val. (Values By default, truncation is done with respect to the current TimeZone setting, but the optional time_zone argument can be provided to specify a different time zone. The time zone name can be specified in are date_add(), date_subtract(), and generate_series(). • Change date_trunc(unit, timestamptz, time_zone) to be an immutable function (Przemyslaw Sztoch) This allows the creation of expression indexes0 码力 | 2974 页 | 14.22 MB | 1 年前3
PostgreSQL 14.10 Documentationdate_trunc is conceptually similar to the trunc function for numbers. date_trunc(field, source [, time_zone ]) source is a value expression of type timestamp, timestamp with time zone, or interval. (Values By default, truncation is done with respect to the current TimeZone setting, but the optional time_zone argument can be provided to specify a different time zone. The time zone name can be specified in0 码力 | 3032 页 | 13.27 MB | 1 年前3
PostgreSQL 14.10 Documentationdate_trunc is conceptually similar to the trunc function for numbers. date_trunc(field, source [, time_zone ]) source is a value expression of type timestamp, timestamp with time zone, or inter- val. (Values By default, truncation is done with respect to the current TimeZone setting, but the optional time_zone argument can be provided to specify a different time zone. The time zone name can be specified in0 码力 | 2871 页 | 13.38 MB | 1 年前3
PostgreSQL 13.13 Documentationdate_trunc is conceptually similar to the trunc function for numbers. date_trunc(field, source [, time_zone ]) source is a value expression of type timestamp, timestamp with time zone, or inter- val. (Values By default, truncation is done with respect to the current TimeZone setting, but the optional time_zone argument can be provided to specify a different time zone. The time zone name can be specified in0 码力 | 2782 页 | 13.00 MB | 1 年前3
PostgreSQL 12.17 Documentationsimilar to the trunc function for numbers. 267 Functions and Operators date_trunc(field, source [, time_zone ]) source is a value expression of type timestamp, timestamp with time zone, or inter- val. (Values By default, truncation is done with respect to the current TimeZone setting, but the optional time_zone argument can be provided to specify a different time zone. The time zone name can be specified in0 码力 | 2786 页 | 12.72 MB | 1 年前3
PostgreSQL 12.17 Documentationdate_trunc is conceptually similar to the trunc function for numbers. date_trunc(field, source [, time_zone ]) source is a value expression of type timestamp, timestamp with time zone, or interval. (Values By default, truncation is done with respect to the current TimeZone setting, but the optional time_zone argument can be provided to specify a different time zone. The time zone name can be specified in0 码力 | 2943 页 | 12.61 MB | 1 年前3
PostgreSQL 13.14 Documentationdate_trunc is conceptually similar to the trunc function for numbers. date_trunc(field, source [, time_zone ]) source is a value expression of type timestamp, timestamp with time zone, or interval. (Values By default, truncation is done with respect to the current TimeZone setting, but the optional time_zone argument can be provided to specify a different time zone. The time zone name can be specified in0 码力 | 2940 页 | 12.89 MB | 1 年前3
PostgreSQL 15.5 Documentationdate_trunc is conceptually similar to the trunc function for numbers. date_trunc(field, source [, time_zone ]) source is a value expression of type timestamp, timestamp with time zone, or inter- val. (Values By default, truncation is done with respect to the current TimeZone setting, but the optional time_zone argument can be provided to specify a different time zone. The time zone name can be specified in0 码力 | 2910 页 | 13.60 MB | 1 年前3
PostgreSQL 15.5 Documentationdate_trunc is conceptually similar to the trunc function for numbers. date_trunc(field, source [, time_zone ]) source is a value expression of type timestamp, timestamp with time zone, or interval. (Values By default, truncation is done with respect to the current TimeZone setting, but the optional time_zone argument can be provided to specify a different time zone. The time zone name can be specified in0 码力 | 3073 页 | 13.49 MB | 1 年前3
共 12 条
- 1
- 2













