timestamp/now in views
| От | Graeme Merrall |
|---|---|
| Тема | timestamp/now in views |
| Дата | |
| Msg-id | LPBBIEJIINGFPCAOHOMCIECBCFAA.gmerrall@email.com обсуждение исходный текст |
| Ответы |
Re: [SQL] timestamp/now in views
Re: [SQL] timestamp/now in views |
| Список | pgsql-sql |
Sorry for being an idiot but I saw something similar to this in the docs but haven't been able to find it since. I tried creating a view using the following syntax CREATE VIEW prev_day AS SELECT * FROM audit WHERE audit_datetime > (current_timestamp - interval'24 hours'); Now as some of you will pick up, this creates a view with the current timestamp set to the creation time of the view, not the actual time the view was executed. I hacked around with various combos of quote marks and tried now() and so on, but to no avail. Can someone enlighten me? Cheers,Graeme
В списке pgsql-sql по дате отправления: