Creating View defining validtime with last second of yesterday

General
Highlighted
New Member

Creating View defining validtime with last second of yesterday

Hi,

 

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 )

       select...

 

I dont know if have a better solution, but it worked for us.

 

Thanks