Re: timestamp no fractional seconds

2009/6/2 Brandon Metcalf <brandon(at)geronimoalloys(dot)com>:
> b == brandon(at)geronimoalloys(dot)com writes:
>
>  b> I need to create a table with two columns of type timestamp but I
>  b> don't want to store any fractional part of the seconds field.  So,
>  b> I created a table with:
>
>  b>   CREATE TABLE timeclock (
>  b>       timeclock_id  SERIAL,
>  b>       employee_id   INTEGER,
>  b>       clockin       TIMESTAMP[0]    NOT NULL,
>  b>       clockout      TIMESTAMP[0]    DEFAULT NULL,
>
>  b>       PRIMARY KEY (timeclock_id),
>
>  b>       FOREIGN KEY (employee_id)
>  b>           REFERENCES employee
>  b>           ON DELETE RESTRICT
>  b>           ON UPDATE CASCADE
>  b>   );
>
>  ...
>
>  b> Am I creating the table correctly?  If so, how do I insert or update
>  b> rows?
>
>
> I suppose my question really boils down to how do I cast the timestamp
> with no fractional seconds part?  For example, if I have a table where
> I haven't put a limit on the fractional seconds part, how would I
> select the timestamp without fractional seconds?
>
>
>  gms=> select clockin from timeclock;
>
>            clockin
>  ----------------------------
>   2009-06-02 11:34:21.314392
>  (1 row)
>
>  gms=> select clockin::timestamp without time zone[0] from timeclock;
>  ERROR:  cannot cast type timestamp without time zone to timestamp without time zone[]
>  LINE 1: select clockin::timestamp without time zone[0] from timecloc...
>                          ^
>  gms=> select clockin::timestamp[0] from timeclock;
>  ERROR:  cannot cast type timestamp without time zone to timestamp without time zone[]
>  LINE 1: select clockin::timestamp[0] from timeclock;
>
>
> --
> Brandon
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

postgres=# select now()::timestamp(0);
now
---------------------
2009-06-02 18:42:41
(1 row)

Time: 173,165 ms
postgres=#

regards
Pavel