Re: CURRENT_TIMESTAMP vs actual time
От
Christopher J. Bottaro
Тема
Re: CURRENT_TIMESTAMP vs actual time
Дата
Msg-id
d48cl9$2fn$1@sea.gmane.org
Список
Дерево обсуждения
Re: CURRENT_TIMESTAMP vs actual time "Christopher J. Bottaro" <cjbottaro@alumni.cs.utexas.edu>
Re: CURRENT_TIMESTAMP vs actual time Scott Marlowe <smarlowe@g2switchworks.com>
Re: CURRENT_TIMESTAMP vs actual time Thomas Hallgren <thhal@mailblocks.com>
Re: CURRENT_TIMESTAMP vs actual time Scott Marlowe <smarlowe@g2switchworks.com>
Re: CURRENT_TIMESTAMP vs actual time Thomas Hallgren <thhal@mailblocks.com>
Re: CURRENT_TIMESTAMP vs actual time Alban Hertroys <alban@magproductions.nl>
John DeSoi wrote: > > On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote: > >> I understand that CURRENT_TIMESTAMP marks the beginning of the current >> transaction. I want it to be the actual time. How do I do this? >> timeofday() returns a string, how do I convert that into a TIMESTAMP? > > > timeofday()::timestamp; Great, that did it, thanks. I also found out that you can say CAST(timeofday() AS TIMESTAMP). I assume its the same thing... -- C
В списке pgsql-general по дате отправления