I am having a doubt in inserting data in time field.
I am having a table in which in column in timestamp without time zone datatype. I want to insert a row into the table but that time field has no value if I insert omitting that column error occurs...
for eg.
Expand|Select|Wrap|Line Numbers
- CREATE TABLE blah
- (
- uuid integer NOT NULL DEFAULT nextval('universal_sq'::regclass),
- "time" timestamp without time zone
- )
- WITHOUT OIDS;
Expand|Select|Wrap|Line Numbers
- insert into blah (uuid,time)values (5,'')
Expand|Select|Wrap|Line Numbers
- ERROR: invalid input syntax for type timestamp: ""
- SQL state: 22007