Skip to content
Advertisement

Generate random date into series [closed]

I use this SQL query to generate random data:

I get this error:

What is the proper way to generate random date?

Advertisement

Answer

Fixed the created_at expression

(NOW() + '90 days' - NOW()) is equivalent to interval 'P90DT1H' because of the summer time one hour shift.

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement