Randomise Date Column

This is a useful statement for when you need help randomizing your date data for testing purposes. In this case, I’m assuming you’ve inserted a certain amount of test data into your table but it’s all showing the same date. First of all: temporarily disable any triggers that you have that will affect this table. Modify this statement to fit your needs: update TABLE_NAME set … Continue reading Randomise Date Column