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.