# @northguild/gmt/precision > Nanosecond instants and the timestamps other systems store: NTP, Arrow, Excel and .NET ticks, plus UUID, ULID and KSUID time. Back to the [root llms.txt](https://northguild.dev/gmt/llms.txt). ## calculate - [truncateNanoseconds](https://northguild.dev/gmt/reference/precision/calculate/truncateNanoseconds.md): Truncate nanoseconds since the Unix epoch to the precision a store can actually hold. ## convert - [ArrowTimeUnit](https://northguild.dev/gmt/reference/types/ArrowTimeUnit.md): The unit of an Apache Arrow `Timestamp` column: Temporal's unit names, singular or plural, matching Arrow's `TimeUnit` (`SECOND`, `MILLISECOND`, `MICROSECOND`, `NANOSECOND`). - [ExcelDateSystem](https://northguild.dev/gmt/reference/types/ExcelDateSystem.md): Which Excel date system a serial belongs to. - [fromArrowLocalTimestamp](https://northguild.dev/gmt/reference/precision/convert/fromArrowLocalTimestamp.md): Convert the `int64` of an Apache Arrow `Timestamp` column that has no timezone to a wall-clock date-time string. - [fromArrowTimestamp](https://northguild.dev/gmt/reference/precision/convert/fromArrowTimestamp.md): Convert the `int64` of an Apache Arrow `Timestamp` column that has a timezone to a UTC instant string. - [fromDotNetTicks](https://northguild.dev/gmt/reference/precision/convert/fromDotNetTicks.md): Convert .NET `DateTime.Ticks` back to an ISO 8601 instant string. - [fromExcelSerial](https://northguild.dev/gmt/reference/precision/convert/fromExcelSerial.md): Convert an Excel day serial back to an ISO 8601 instant string. - [fromFileTime](https://northguild.dev/gmt/reference/precision/convert/fromFileTime.md): Convert a Windows `FILETIME` back to an ISO 8601 instant string. - [fromNanoseconds](https://northguild.dev/gmt/reference/precision/convert/fromNanoseconds.md): Convert nanoseconds since the Unix epoch back to an ISO 8601 string. - [fromNtpTimestamp](https://northguild.dev/gmt/reference/precision/convert/fromNtpTimestamp.md): Convert a 64-bit NTP timestamp (RFC 5905) back to an ISO 8601 instant string. - [fromParquetInt96](https://northguild.dev/gmt/reference/precision/convert/fromParquetInt96.md): Convert a Parquet `INT96` timestamp back to an ISO 8601 instant string. - [fromPgMicroseconds](https://northguild.dev/gmt/reference/precision/convert/fromPgMicroseconds.md): Convert PostgreSQL's internal `timestamptz` value back to an ISO 8601 instant string. - [fromProtoDuration](https://northguild.dev/gmt/reference/precision/convert/fromProtoDuration.md): Convert a protobuf `google.protobuf.Duration` record back to an ISO 8601 duration string. - [fromProtoTimestamp](https://northguild.dev/gmt/reference/precision/convert/fromProtoTimestamp.md): Convert a protobuf `google.protobuf.Timestamp` record back to an ISO 8601 instant string. - [ParquetInt96](https://northguild.dev/gmt/reference/types/ParquetInt96.md): A Parquet `INT96` timestamp as most readers expose it: a Julian Day Number and the nanoseconds into that day. - [ProtoDuration](https://northguild.dev/gmt/reference/types/ProtoDuration.md): A protobuf `google.protobuf.Duration` as protobuf libraries expose it. - [ProtoTimestamp](https://northguild.dev/gmt/reference/types/ProtoTimestamp.md): A protobuf `google.protobuf.Timestamp` as protobuf libraries expose it. - [toArrowLocalTimestamp](https://northguild.dev/gmt/reference/precision/convert/toArrowLocalTimestamp.md): Convert an ISO 8601 plain date-time to the `int64` of an Apache Arrow `Timestamp` column that has no timezone. - [toArrowTimestamp](https://northguild.dev/gmt/reference/precision/convert/toArrowTimestamp.md): Convert an ISO 8601 instant string to the `int64` of an Apache Arrow `Timestamp` column that has a timezone. - [toDotNetTicks](https://northguild.dev/gmt/reference/precision/convert/toDotNetTicks.md): Convert an ISO 8601 instant string to .NET `DateTime.Ticks`. - [toExcelSerial](https://northguild.dev/gmt/reference/precision/convert/toExcelSerial.md): Convert an ISO 8601 instant string to an Excel day serial. - [toFileTime](https://northguild.dev/gmt/reference/precision/convert/toFileTime.md): Convert an ISO 8601 instant string to a Windows `FILETIME`. - [toNanoseconds](https://northguild.dev/gmt/reference/precision/convert/toNanoseconds.md): Convert an ISO 8601 instant string to nanoseconds since the Unix epoch. - [toNtpTimestamp](https://northguild.dev/gmt/reference/precision/convert/toNtpTimestamp.md): Convert an ISO 8601 instant string to a 64-bit NTP timestamp (RFC 5905). - [toParquetInt96](https://northguild.dev/gmt/reference/precision/convert/toParquetInt96.md): Convert an ISO 8601 instant string to a Parquet `INT96` timestamp record. - [toPgMicroseconds](https://northguild.dev/gmt/reference/precision/convert/toPgMicroseconds.md): Convert an ISO 8601 instant string to PostgreSQL's internal `timestamptz` value. - [toProtoDuration](https://northguild.dev/gmt/reference/precision/convert/toProtoDuration.md): Convert an ISO 8601 duration string to a protobuf `google.protobuf.Duration` record. - [toProtoTimestamp](https://northguild.dev/gmt/reference/precision/convert/toProtoTimestamp.md): Convert an ISO 8601 instant string to a protobuf `google.protobuf.Timestamp` record. ## format - [formatNanoseconds](https://northguild.dev/gmt/reference/precision/format/formatNanoseconds.md): Format nanoseconds since the Unix epoch as a decimal string, for JSON and other text transports. ## identifiers - [fromKsuid](https://northguild.dev/gmt/reference/precision/identifiers/fromKsuid.md): Read the instant a KSUID carries (segmentio/ksuid, `ksuid.go` and `base62.go`). - [fromObjectId](https://northguild.dev/gmt/reference/precision/identifiers/fromObjectId.md): Read the creation second a MongoDB ObjectId carries (mongodb/specifications `bson-objectid/objectid.md`, § Specification and § Timestamp Field). - [fromSnowflake](https://northguild.dev/gmt/reference/precision/identifiers/fromSnowflake.md): Read the instant a Snowflake id carries, using a layout the caller supplies. - [fromUlid](https://northguild.dev/gmt/reference/precision/identifiers/fromUlid.md): Read the instant a ULID carries (ulid/spec README, § Components and § Canonical String Representation). - [fromUuidTimestamp](https://northguild.dev/gmt/reference/precision/identifiers/fromUuidTimestamp.md): Read the instant a version 1, 6 or 7 UUID carries (RFC 9562 §5.1, §5.6, §5.7). - [ulidTimestampPrefix](https://northguild.dev/gmt/reference/precision/identifiers/ulidTimestampPrefix.md): The first 10 characters of every ULID minted in the same millisecond as an instant, for range scans over stored ULID text (ulid/spec README, § Components and § Encoding). - [uuidV7TimestampPrefix](https://northguild.dev/gmt/reference/precision/identifiers/uuidV7TimestampPrefix.md): The first 13 characters of every version 7 UUID minted in the same millisecond as an instant, for range scans over stored UUID text (RFC 9562 §5.7, §6.11). ## parse - [parseNanoseconds](https://northguild.dev/gmt/reference/precision/parse/parseNanoseconds.md): Parse a decimal string produced by `formatNanoseconds` — typically one field of a JSON payload — back to nanoseconds since the Unix epoch. ## validate - [isValidInstant](https://northguild.dev/gmt/reference/precision/validate/isValidInstant.md): Validate whether a string is an ISO 8601 instant string the `precision/` namespace accepts. - [isValidInt64NanosecondDateTime](https://northguild.dev/gmt/reference/precision/validate/isValidInt64NanosecondDateTime.md): Validate whether a string is a plain date-time whose epoch-nanosecond count, read as if it were UTC (Arrow's rule for a zoneless timestamp), fits an `int64`: the check to run before `toArrowLocalTimestamp(dateTime, "nanosecond")`. - [isValidInt64NanosecondInstant](https://northguild.dev/gmt/reference/precision/validate/isValidInt64NanosecondInstant.md): Validate whether a string is an instant whose epoch-nanosecond count fits an `int64`: the check to run before `toArrowTimestamp(isoString, "nanosecond")`. - [isValidNanoPattern](https://northguild.dev/gmt/reference/precision/validate/isValidNanoPattern.md): Validate whether a string is a nanosecond timestamp `parseNanoseconds` will parse. - [isValidNanoseconds](https://northguild.dev/gmt/reference/precision/validate/isValidNanoseconds.md): Validate whether a value is an epoch-nanosecond `bigint` the `precision/` namespace accepts.