Guys, I want to share a solution that I did today to solve a simple developing requirement.
The requirement was to create views that return the snapshot of last second of yesterday.
The solution that I done:
REPLACE VIEW [SCHEMA].[VW_NAME] AS LOCKING ROW FOR ACCESS MODE
VALIDTIME AS OF (cast(date as timestamp) - INTERVAL '1' SECOND )
I dont know if have a better solution, but it worked for us.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.