The Fauna service will be ending on May 30, 2025.

For more information on the service wind down, see our announcement and the Fauna Service End-of-Life FAQ.

DayOfYear

This reference topic applies to FQL v4. Go to this page for the latest FQL v10 reference topics.

 
DayOfYear( timestamp )
day_of_year( timestamp )
DayOfYear( timestamp )
DayOfYear( timestamp )
DayOfYear( timestamp )
DayOfYear( timestamp )

Description

The DayOfYear function extracts the day of the year from a Timestamp.

Parameters

Parameter Type Definition and Requirements

timestamp

Timestamp

A timestamp.

Returns

A Number which represents the value of the day of the year, in the range 1 to 366, from the provided timestamp.

Examples

The following query returns the day of the year from a timestamp:

client.query(
  q.DayOfYear(q.Time('2019-04-29T12:51:17Z'))
)
.then((ret) => console.log(ret))
.catch((err) => console.error(
  'Error: [%s] %s: %s',
  err.name,
  err.message,
  err.errors()[0].description,
))
119
result = client.query(
  q.day_of_year(q.time("2019-04-29T12:51:17Z"))
)
print(result)
119
result, err := client.Query(
	f.DayOfYear(f.Time("2019-04-29T12:51:17Z")))

if err != nil {
	fmt.Fprintln(os.Stderr, err)
} else {
	fmt.Println(result)
}
119
try
{
    Value result = await client.Query(
        DayOfYear(Time("2019-04-29T12:51:17Z"))
    );
    Console.WriteLine(result);
}
catch (Exception e)
{
    Console.WriteLine($"ERROR: {e.Message}");
}
LongV(119)
System.out.println(
    client.query(
        DayOfYear(Time(Value("2019-04-29T12:51:17Z")))
    ).get()
);
119
DayOfYear(Time('2019-04-29T12:51:17Z'))
119
Query metrics:

  •    bytesIn:  47

  •   bytesOut:  16

  • computeOps:   1

  •    readOps:   0

  •   writeOps:   0

  •  readBytes:   0

  • writeBytes:   0

  •  queryTime: 2ms

  •    retries:   0

\