Re: CURRENT_TIMESTAMP vs actual time

Try SELECT timeofday()::TIMESTAMP;

Regards,

Ben
""Christopher J. Bottaro"" <cjbottaro(at)alumni(dot)cs(dot)utexas(dot)edu> wrote in message
news:d46k11$6nc$1(at)sea(dot)gmane(dot)org(dot)(dot)(dot)
> Hi,
> 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?
>
> Is it possible to create a column with DEFAULT value evaluated to the
> actual
> current time (i.e. not the CURRENT_TIMESTAMP which is the beginning of the
> current transaction).
>
> What I do now to get it to work is do a COMMIT right before the insert,
> that
> way CURRENT_TIMESTAMP is (pretty close to) the actual time. ...but that
> is
> so crappy and doesn't work if I actually need to use transactional
> features
> (i.e. rollback).
>
> Thanks for the help,
> -- C
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>