liveBook · Manning

Time

TIME is a temporal data type representing a time of day without calendar-date information, optionally with fractional-second precision.

How 2 Manning books explain it

ScyllaDB in Action

A time is a database data type representing a time of day with fractional-second precision.

How it is used
Stores a time of day when a date is unnecessary.
How deep it goes
Explains representation, accepted inputs, precision, rendering, validation, and conversions without developing database internals.
Examples
Uses ISO-style time strings, nanosecond integer values, and cqlsh INSERT and SELECT results.
What you can do after
Operate TIME through CQL and cqlsh using readable values or nanosecond integers.

Read how ScyllaDB in Action explains time →

Grokking Relational Database Design

A TIME data type stores a time of day without calendar-date information.

How it is used
Stores a time of day for events whose calendar date is unnecessary.
How deep it goes
Defines TIME and distinguishes it from related temporal types without discussing implementation details.
Examples
Uses a review_time attribute and the value '14:30:00' to illustrate time-of-day storage.

Read how Grokking Relational Database Design explains time →

What to know first

Related concepts

Questions about time

What is time?

TIME is a temporal data type representing a time of day without calendar-date information, optionally with fractional-second precision.

Which Manning books explain time?

ScyllaDB in Action and Grokking Relational Database Design.

What should I know before learning time?

Manning books that teach time usually introduce timestamp first.

What is time a kind of?

Time is a kind of date. A date is a calendar-based value identifying a particular day, optionally represented with associated time information.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.