2008/11/26, Guilherme Vianna de Aguiar <[EMAIL PROTECTED]>: > > desde terça-feira dia 24 estou com um problema de carga em uma tabela que > tem um dos campos de tipo timestamp. > > > > A definição do campo: > > "date_time" TIMESTAMP WITHOUT TIME ZONE DEFAULT (timeofday())::timestamp > without time zone NOT NULL > > > > O erro: > > ERROR: invalid input syntax for type timestamp: "Wed Nov 26 15:58:37.293074 > 2008 BRDT" > > > > A versão do banco é 8.2.4. >
Tente usar a função clock_timestamp() no lugar da timeofday(). http://www.postgresql.org/docs/current/interactive/functions-datetime.html "clock_timestamp() returns the actual current time, and therefore its value changes even within a single SQL command. timeofday() is a historical PostgreSQL function. Like clock_timestamp(), it returns the actual current time, but as a formatted text string rather than a timestamp with time zone value." Osvaldo _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
