Date Time Based Fields in SomaDB

Date and time fields handle temporal data with various formats and precision levels. These fields are essential for tracking events, scheduling, and time-based analysis.

Date Time Based Field Types

Date Time

• Use Case: Timestamps, event times
• Features: Full date and time with timezone support
• Validation: Valid date and time format

Date

• Use Case: Birthdays, deadlines, dates
• Features: Date only without time
• Validation: Valid date format

Time

• Use Case: Meeting times, durations
• Features: Time only without date
• Validation: Valid time format

Duration

• Use Case: Time spans, intervals
• Features: Duration calculation and display
• Validation: Valid duration format

Created Time

• Use Case: Record creation tracking
• Features: Automatic timestamp on record creation
• Validation: System-generated timestamp

Last Modified Time

• Use Case: Change tracking, audit trails
• Features: Automatic timestamp on record updates
• Validation: System-generated timestamp

Key Features

• Timezone Support: Handle different timezones
• Formatting Options: Customize date and time display
• Validation: Ensure valid date and time values
• Calculation Support: Use in date arithmetic

Best Practices

• Choose appropriate precision for your needs
• Consider timezone requirements
• Use system fields for audit trails
• Plan for date range validation
• Consider performance with date queries

Next Steps

Explore each date and time field type to learn more about their specific features and use cases.