From: | "Mauro A(dot) Morales M(dot)" <mmorales(at)opencorp(dot)cl> |
---|---|
To: | Manuel Sánchez Tirado Calderón <manuelstc(at)gmail(dot)com>, pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: Problemas INSERT con TIMESTAMP |
Date: | 2009-01-13 23:29:49 |
Message-ID: | 1231889389.3492.2.camel@sherlock |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
El mar, 13-01-2009 a las 15:25 -0500, Manuel Sánchez Tirado Calderón
escribió:
> insert into log_usuario values('01', '0325464', 'MSANCHEZ', now(),
> '10.1.1.1')
En mi postgresql 8.3.5, sobre un fedora 9 ...
test=# CREATE TABLE log_usu
test-# (
test(# tipusu char(2),
test(# inscodigo char(7),
test(# nomusu varchar(15),
test(# fecing timestamp,
test(# ipacceso varchar(20)
test(# );
CREATE TABLE
test=# insert into log_usu values('01', '0325464', 'MSANCHEZ', now(),
'10.1.1.1');
INSERT 0 1
test=# select * from log_usu;
tipusu | inscodigo | nomusu | fecing | ipacceso
--------+-----------+----------+----------------------------+----------
01 | 0325464 | MSANCHEZ | 2009-01-13 20:26:40.841255 | 10.1.1.1
(1 fila)
--
Mauro A. Morales M. http://www.opencorp.cl
Opencorp Ltda. Ingenieria Opensource
From | Date | Subject | |
---|---|---|---|
Next Message | Javier Chávez B. | 2009-01-13 23:52:31 | Re: Cubos Dimensionales |
Previous Message | Marco Antonio Ruiz Grández | 2009-01-13 23:14:47 | Re: Cubos Dimensionales |