Function PGWireFormatTimestamp

pkg/sql/sem/tree/pgwire_encode.go:344–381

PGWireFormatTimestamp formats t into a format lib/pq understands. If offset is not nil, it will not display the timezone offset.

(t time.Time, offset *time.Location, tmp []byte)

// PGWireFormatTimestamp formats t into a format lib/pq understands.
// If offset is not nil, it will not display the timezone offset.
func PGWireFormatTimestamp(t time.Time, offset *time.Location, tmp []byte) (b []byte) {
	if t == pgdate.TimeInfinity {
		return []byte("infinity")
	}
	if t == pgdate.TimeNegativeInfinity {
		return []byte("-infinity")
	}

	format := PGTimeStampFormatNoOffset
	if offset != nil {
		format = PGTimeStampFormat
		if _, offsetSeconds := t.In(offset).Zone(); offsetSeconds%60 != 0 {
			format += ":00:00"
		} else if offsetSeconds%3600 != 0 {
			format += ":00"
		}
	}

	// Need to send dates before 0001 A.D. with " BC" suffix, instead of the
	// minus sign preferred by Go.
	// Beware, "0000" in ISO is "1 BC", "-0001" is "2 BC" and so on
	if offset != nil {
		t = t.In(offset)
	}

	bc := false
	if t.Year() <= 0 {
		// flip year sign, and add 1, e.g: "0" will be "1", and "-10" will be "11"
		t = t.AddDate((-t.Year())*2+1, 0, 0)
		bc = true
	}

	b = t.AppendFormat(tmp, format)
	if bc {
		b = append(b, " BC"...)
	}
	return b
}