Function formatTimestampWithTz

frontend/src/utils/v1/sql.ts:110–136

(timestampTzValue: RowValue_TimestampTZ)

};

const formatTimestampWithTz = (timestampTzValue: RowValue_TimestampTZ) => {
  const fullDayjs = dayjs(
    getDateForPbTimestampProtoEs(timestampTzValue.googleTimestamp)
  )
    .utc()
    .add(timestampTzValue.offset, "seconds");

  const hourOffset = Math.floor(timestampTzValue.offset / 60 / 60);
  const timezoneOffsetPrefix = Math.abs(hourOffset) < 10 ? "0" : "";
  const timezoneOffset =
    hourOffset > 0
      ? `+${timezoneOffsetPrefix}${hourOffset}`
      : `-${timezoneOffsetPrefix}${Math.abs(hourOffset)}`;
  // Use a local rather than writing back to `timestampTzValue.accuracy`:
  // the RowValue comes from the immer-frozen Zustand result set, so an
  // in-place assignment throws "Cannot assign to read only property".
  const accuracy =
    timestampTzValue.accuracy === 0 ? 6 : timestampTzValue.accuracy;
  const microseconds = Math.floor(
    (timestampTzValue.googleTimestamp?.nanos ?? 0) / Math.pow(10, 9 - accuracy)
  );
  const formattedTimestamp =
    microseconds > 0
      ? `${fullDayjs.format("YYYY-MM-DD HH:mm:ss")}.${microseconds.toString().padStart(accuracy, "0")}${timezoneOffset}`
      : `${fullDayjs.format("YYYY-MM-DD HH:mm:ss")}${timezoneOffset}`;
  return formattedTimestamp;
};

const escapeMongoDBCollectionName = (name: string) => {
  // The backend wraps --eval in single quotes for shell execution and escapes