Is there a standard for how data is represented in a Saved View where a timestamp/voltatile expression is used? For example, let's say I have the SQL query:
SELECT person_id, name, NOW() as now FROM table
The NOW()
function will have a different value every time it is run. When saving the above to a view, is the data stored as:
person_id name now
1 Bob 2020-01-01T01:01:01
2 Billy 2020-01-01T01:01:01
3 Barbara 2020-01-01T01:01:01
Or is it stored as:
person_id name now
1 Bob =NOW()
2 Billy =NOW()
3 Barbara =NOW()
Or, is it dependent on the database implementation and there is no standard?
See Question&Answers more detail:os