All pastes #26368 Raw Edit

Unnamed

public text v1 · immutable
#26368 ·published 2005-10-23 12:45 UTC
rendered paste body
postgres8:

CREATE TABLE "InetLog" (
    "ID" bigint DEFAULT nextval('public."InetLog_ID_seq"'::text) NOT NULL,
    "Void" boolean DEFAULT false NOT NULL,
    "StartTime" timestamp without time zone NOT NULL,
    "Duration" interval NOT NULL,
    "MacAddress" macaddr NOT NULL
);



inet=> insert into "InetLog" values(default,true,'2005-23-10 16:30:02',90,'AA:BB:CC:DD:EE:FF');
ERROR:  date/time field value out of range: "2005-23-10 16:30:02"
HINT:  Perhaps you need a different "datestyle" setting.



inet=> insert into "InetLog" values(default,true,'2005-23-10T16:30:02',90,'AA:BB:CC:DD:EE:FF');
ERROR:  date/time field value out of range: "2005-23-10T16:30:02"
HINT:  Perhaps you need a different "datestyle" setting.

any idea why this does not work ?