Time
TIME is a temporal data type representing a time of day without calendar-date information, optionally with fractional-second precision.
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.
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
- timestampA timestamp is a value representing a specific point in time, commonly associated with an event or data item.
Related concepts
- datekind of · A date is a calendar-based value identifying a particular day, optionally represented with associated time information.
- data typekind of · A data type classifies values by their permitted forms or representations and the operations or interpretations applicable to them.
- daylight saving timeuses · Daylight saving time is a seasonal civil-time convention in which a locality adjusts its clocks relative to standard time.
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.

