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 по дате отправления
От: Zlatko Matic
Дата:
От: Alvaro Herrera
Дата:
FAQ