Re: [PORTS] 'current'::datetime
| От | Thomas Lockhart |
|---|---|
| Тема | Re: [PORTS] 'current'::datetime |
| Дата | |
| Msg-id | 3801FE61.F4EB473F@alumni.caltech.edu обсуждение исходный текст |
| Ответ на | 'current'::datetime (Peter Schaefer <schaefer@cys.de>) |
| Список | pgsql-ports |
> Excuse me does the 'current'::datetime work ?
Sure. But the behavior one might want from 'current' requires that
printing or representing it in its raw form preserves its
"current-ness". If you want 'current' instantiated into a time, you
have to do some math, or some other operation which will nail it to
the time you evaluate it. Here is an example:
postgres=> select datetime 'now' as now,
postgres-> datetime 'current' as current,
postgres-> datetime 'current' + timespan '0 sec' as equiv;
now |current|equiv
----------------------+-------+----------------------
1999-10-11 15:09:58+00|current|1999-10-11 15:09:58+00
(1 row)
Hope this helps. Good luck.
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
В списке pgsql-ports по дате отправления: