Hour

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

 
Hour( timestamp )
hour( timestamp )
Hour( timestamp )
Hour( timestamp )
Hour( timestamp )
Hour( timestamp )

Description

The Hour function extracts the hour from a Timestamp.

Parameters

Parameter Type Definition and Requirements

timestamp

Timestamp

A timestamp.

Returns

A Number which represents the value of the hour, in the range 0 to 23, from the provided timestamp.

Examples

The following query returns the hour from a timestamp:

client.query(
  q.Hour(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,
))
12
result = client.query(
  q.hour(q.time("2019-04-29T12:51:17Z"))
)
print(result)
12
result, err := client.Query(
	f.Hour(f.Time("2019-04-29T12:51:17Z")))

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

  •    bytesIn:  40

  •   bytesOut:  15

  • computeOps:   1

  •    readOps:   0

  •   writeOps:   0

  •  readBytes:   0

  • writeBytes:   0

  •  queryTime: 1ms

  •    retries:   0

\