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 →
Related concepts
- datekind of · A date is a calendar value identifying a particular day.
- data typekind of · A data type classifies values and specifies their representation or interpretation and the operations 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.
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.