How to generate ordered SQL datetime values?

Hi! I can’t figure how to generating an ordered SQL datetime values. Is it possible to generate ordered SQL datetime values incremented in each iteration with N number of hours ?

Example:

2017-04-01 00:00:00
2017-04-01 03:00:00
2017-04-01 06:00:00
2017-04-01 09:00:00

2017-04-02 12:00:00
2017-04-02 15:00:00
2017-04-02 18:00:00
2017-04-02 21:00:00

Any advice and suggestions will be greatly appreciated. :slight_smile:

The only way to do this in mockaroo is using a formula. Start with a base datetime and increment based on a sequence or row number. Here’s an example:

Thank you @mockaroo for the response.

but I can’t acess the page, the link is broken :

Sorry about that. Here is the correct link >> http://mockaroo.com/cbd5c970

1 Like

This post was flagged by the community and is temporarily hidden.

SELECT *
FROM TABLENAME
WHERE DateTime >= 12/04/2011 12:00:00 AM
AND DateTime <= 25/05/2011 3:53:04 AM

this is an SQL Query that generating an ordered SQL datetime value.Windows Error Code 43

You can simply generate ordered date-time values by coding of the SQL. you can also use the Pre-define function. For instant support related to the Roadrunner email please call Roadrunner Email Support Number for the best solution.

You can do it by addint some refernce code in your SQL data base. Learn more about it on mockaroo Repeated locations within country

Hey! You can simply generate ordered date-time values by coding of the SQL. You can do it by addint some refernce code in your SQL data base, Learn more about it on mockaroo.com