I like using the Quick Sql option within Apex. The /values option does a nice job filling the created tables with values.
But the way date fields get assigned a value is not to my liking. It seems that all dates get a value of sysdate - x (random number), regardless of what I assign using the /values option.
I tried forcing other fixed data with /values sysdate-100, sysdate-200 etc but this seems to be ignored (no errors, but not the desired effect).
Does anybody know how I can influence/ override this?
It would not be much of a problem if dates would also get assigned future dates. Especially when tables have start_date and end_date fields, and you application needs checks on these dates like
sysdate between start_date and end_date, is it annoying that now records get returned because all the end-date have a date in the past.
Or can I somehow add 'code' to the end of my Quick Sql script to update all end-dates?
something like
update <table> end_date /value sysdate+100
Of course, I can add this code to the generated creation script, but I would lose that code every time I make a change to my quick sql code.