Timestamp Standard

by TrueNine

data

Frontend-backend time data transmission standard, using millisecond timestamps for time points (timezone-independent); Duration/Period use ISO 8601 string format.

Skill Details

Repository Files

1 file in this skill directory


name: timestamp-standard description: Frontend-backend time data transmission standard, using millisecond timestamps for time points (timezone-independent); Duration/Period use ISO 8601 string format.

Time Representation Standard

Time Point (Instant)

Type Format Description
Time Point number Millisecond timestamp, UTC-based, timezone-independent

Core Principles:

  • All time points use millisecond timestamps (Unix Epoch Milliseconds)
  • Timestamps are timezone-independent, frontend converts display based on user timezone
  • Database storage, API transmission, frontend-backend interaction all use numeric type

Duration

Type Format Example Description
Duration string PT1H30M ISO 8601 duration format

Duration Format: PT[n]H[n]M[n]S

  • PT1H - 1 hour
  • PT30M - 30 minutes
  • PT1H30M - 1 hour 30 minutes
  • PT45S - 45 seconds
  • PT1H30M45S - 1 hour 30 minutes 45 seconds

Period

Type Format Example Description
Period string P1Y2M3D ISO 8601 date period format

Period Format: P[n]Y[n]M[n]D

  • P1Y - 1 year
  • P2M - 2 months
  • P3D - 3 days
  • P1Y2M3D - 1 year 2 months 3 days

Usage Examples

Interface Definition

interface Event {
  createdAt: number    // 1732608000000
  updatedAt: number    // 1732694400000
  duration: string     // "PT2H30M"
  validPeriod: string  // "P1Y"
}

Frontend Conversion

// timestamp to local display
const display = new Date(timestamp).toLocaleString()

// local time to timestamp
const timestamp = new Date().getTime()

Backend Processing (Kotlin/Java)

// Instant and timestamp conversion
val instant = Instant.ofEpochMilli(timestamp)
val timestamp = instant.toEpochMilli()

// Duration parsing
val duration = Duration.parse("PT1H30M")

// Period parsing
val period = Period.parse("P1Y2M")

Design Philosophy

  • Timestamps: Numeric type for efficient transmission, no timezone ambiguity, cross-language compatible
  • Duration/Period: ISO 8601 standard format, clear semantics, native parsing support

Related Skills

Xlsx

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

data

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

datacli

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

datacli

Analyzing Financial Statements

This skill calculates key financial ratios and metrics from financial statement data for investment analysis

data

Data Storytelling

Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.

data

Kpi Dashboard Design

Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.

designdata

Dbt Transformation Patterns

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

testingdocumenttool

Sql Optimization Patterns

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.

designdata

Anndata

This skill should be used when working with annotated data matrices in Python, particularly for single-cell genomics analysis, managing experimental measurements with metadata, or handling large-scale biological datasets. Use when tasks involve AnnData objects, h5ad files, single-cell RNA-seq data, or integration with scanpy/scverse tools.

arttooldata

Xlsx

Spreadsheet toolkit (.xlsx/.csv). Create/edit with formulas/formatting, analyze data, visualization, recalculate formulas, for spreadsheet processing and analysis.

tooldata

Skill Information

Category:Data
Last Updated:12/3/2025