Andreas Kretschmer schrieb:
>
> Mark Morgan Lloyd <[EMAIL PROTECTED]> wrote:
> > > test=# select now()::time;
> > > now
> > >
> > > 11:16:18.22527
> > > (1 row)
> >
> > Thanks Andreas, I've ended up using CAST( ... AS TIME). I think the ::
> > notation might be fragile in t
Mark Morgan Lloyd <[EMAIL PROTECTED]> schrieb:
> > test=# select now()::time;
> > now
> >
> > 11:16:18.22527
> > (1 row)
>
> Thanks Andreas, I've ended up using CAST( ... AS TIME). I think the ::
> notation
> might be fragile in this instance because of the machine-generat
Andreas Kretschmer schrieb:
>
> Mark Morgan Lloyd <[EMAIL PROTECTED]> wrote:
> > What is the correct (or even any :-) way of converting a timestamp into a
> > time (without timezone etc.)?
>
> You can CAST it:
>
> test=# select now();
> now
> ---
> 2006
Mark Morgan Lloyd <[EMAIL PROTECTED]> schrieb:
> What is the correct (or even any :-) way of converting a timestamp into a time
> (without timezone etc.)?
You can CAST it:
test=# select now();
now
---
2006-11-05 11:16:05.205235+01
(1 row)
test=# select
