Best Of
Re: Are there any examples or videos that show how to use Flyway with Databricks?
https://documentation.red-gate.com/fd/databricks-243272862.html
Are there any specific things you are struggling with ?
Re: SqlHistory.QueryVersions.DateSaved conversion to datetime
Re: recent install, can't access settings
Re: How to use TOML Configuration File
Re: Deploying from a Script Folder to a Database
Re: SqlHistory.QueryVersions.DateSaved conversion to datetime
Hi @Remko1981
Thank you for reaching out on the Redgate forums regarding your question.
I had a look at the SqlHistory.db file and see the column you are referring to. It appears to be some sort of Epoch time but doesn't immediately seem to line up with Unix standard. I can attempt to dig further to see what the actual starting point is, but I do have some python code that may help you.
Example_epoch_ns is where you would enter your SqlHistory.QueryVersions.DateSaved value and it should convert to a current UTC timezone date time value.
Hopefully this is of help with your investigation.
import datetime def custom_epoch_to_datetime(epoch_ns, scaling_factor=0.0778571537083127): # Convert the custom epoch time to seconds time_in_seconds = epoch_ns / (scaling_factor * 1e9) # Convert the seconds to a datetime object in UTC converted_date = datetime.datetime.fromtimestamp(time_in_seconds, tz=datetime.timezone.utc) return converted_date # Example usage example_epoch_ns = 133594612005169990 converted_date = custom_epoch_to_datetime(example_epoch_ns) print(f"Epoch Time: {example_epoch_ns}") print(f"Converted Datetime (UTC): {converted_date}")
And of course it's not recommended to directly modify the *.db file... and to always make appropriate backups before manipulating it outside of SQL Prompt.
Re: Do alerts in SQL Monitor auto clear?
Most checks are executed a few times a day to prevent killing your server with monitor requests.