monolayer / schema / timeWithTimeZone

Function: timeWithTimeZone()

timeWithTimeZone(precision?): PgTimeWithTimeZone

Column that stores times of day (no date) with time zone.

Parameters

Parameter	Type	Description
precision?	DateTimePrecision	Number of fractional digits retained in the seconds field. The allowed range is from 0 to 6.

Returns

PgTimeWithTimeZone

Remarks

Without precision specified, there is no explicit bound on precision.

Kysely database schema type definition

{
  readonly __select__: string | null;
  readonly __insert__: string | null | undefined;
  readonly __update__: string | null;
};

Nullability and optionality will change according to the column's constraints, generated values, and default data values.

Zod Schema

Types:

{
  input?:  string | null | undefined;
  output?: string | null | undefined;
}

Nullability and optionality will change according to the column's constraints, generated values, and default data values.

Validations:

• Explicit undefined values are rejected.
• Input value must be string, or null.
• Non-values must be a valid string that matches a time format.

Example

import { schema, table, timeWithTimeZone } from "monolayer/pg";
import { zodSchema } from "monolayer/zod";

const dbSchema = schema({
  tables: {
    example: table({
      columns: {
        start: timeWithTimeZone(),
      },
    }),
  },
});

// Kysely database schema type
type DB = typeof dbSchema.infer;
// Zod Schema
const schema = zodSchema(database.tables.example);

See

time with time zone (PostgreSQL Docs)