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

#1

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?

#2

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
#3

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.