Function formatTimestamp

console/src/platform/shell/formatRows.ts:16–58

(timestamp: unknown, withTz: boolean)

const FIRST_AD_TIMESTAMP = new Date("0001-01-01T00:00:00Z").getTime();

function formatTimestamp(timestamp: unknown, withTz: boolean): string {
  let timestampNumber = 0;
  if (typeof timestamp === "number") {
    timestampNumber = timestamp;
  } else if (typeof timestamp === "string") {
    timestampNumber = parseInt(timestamp);
    if (isNaN(timestampNumber)) {
      return timestamp;
    }
  } else {
    return JSON.stringify(timestamp);
  }

  // Timestamps are always stored and transmitted in Materialize as UTC. The
  // only difference between the `timestamp without timezone` (`withTz = false`)
  // and `timestamp with timezone` (`withTz = true`) types is whether the time
  // zone indication is included in the format.
  //
  // A future version of Materialize may allow users to configure the
  // `timezone` session parameter, in which case `withTz = true` would need to
  // display the timestamp in the configured time zone. However, at present,
  // Materialize always uses `utc` is as the value for `timezone`, so we can
  // always format the time in UTC.

  let formatted = formatDateInUtc(timestampNumber, "yyyy-MM-dd HH:mm:ss");
  const milliseconds = formatDateInUtc(timestampNumber, "SSS").replace(
    /0*$/,
    "",
  );
  formatted =
    milliseconds.length > 0 ? `${formatted}.${milliseconds}` : formatted;
  if (withTz) {
    // Append UTC timezone
    formatted += "+00";
  }

  const isBcDate = timestampNumber < FIRST_AD_TIMESTAMP;

  if (isBcDate) {
    formatted += " BC";
  }
  return formatted;
}

/**
 * Formats an array for output as psql would.