Is it possible to generate data in hourly increments using Date type and SQL datetime

Would it be possible to have the option to choose hourly increments in addition to full days when setting the date range for a SQL datetime field?

Or could someone give me a general idea how to do it using a formula?

You can do this using a formula like:

date('1/1/2017 14:00:00') + hours(random(0, 48))

This will generate a date and time between 0 and 48 hours after 1:00pm on 1/1/2017.

2 Likes

It is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.
directory submission sites list
The directory submission process will help you increase your website’s domain-authority, page-authority, PageRank, backlinks graph, and organic search ranking.