Showing subgraph timestamp results in human-readable format

Question

My subgraph as a UNIX timestamp as seconds defined as the following

type TokenSwap @entity {
  id: ID!

  # UNIX timestamp of block in which the swap was created
  timestamp: BigInt!
}

When I am experimenting in TheGraph playground, is there a way for me to display this as UTC time, instead of raw seconds since the UNIX epoch? This would make the playground output more readable.

score 1 · Accepted Answer · answered Oct 10 '22 at 00:14

The single responsibility of Graphql is to fetch a defined query, it doesn't support formatting data so you won't be able to do that in the playground.

It is possible to define a custom scalar type for a Date to control how it is serialized, deserialized, and validated source

Unfortunately, a date type is not included in the scalar types supported by The Graph source

One solution would be to add an additional field with the human readable timestamp for convenience.

// schema 
type TokenSwap @entity {
  id: ID!

  # ISO String of block in which the swap was created
  isoString: String!
}

// handler
tokenswap.isoString = new Date(1665360258621).toISOString()

Showing subgraph timestamp results in human-readable format

1 Answers1