How to generate ordered SQL datetime values?

#1

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:

#2

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:

#3

Thank you @mockaroo for the response.

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

Capture du 2017-03-27 14:27:19.png1365×229 12.1 KB

#4

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

1 Like
#5

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

#6

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

#7

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.

#8

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

#9

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