Date time insertion

From: Bob Kruger <bkruger(at)mindspring(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Date time insertion
Date: 1999-06-23 19:06:54
Message-ID: 3.0.5.32.19990623140654.007d9d60@mindspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql


I am trying to insert both the date and the time into a datetime field.

If the field datetime in table v1 is dt, then the following successfully
inserts the date into the datetime field:

insert into v1 (date) values ('19990401') ;

However, if I also wanted to retain the time of day, the following does not
work:

insert into v1 (date) values ('199904011530') ;

Any hints?

Thanks in advance.

Regards - Bob Kruger

Browse pgsql-general by date

  From Date Subject
Next Message Matt Magoffin (Borders Online) 1999-06-23 19:35:32 RE: [GENERAL] ERROR: typeidTypeRelid: Invalid type - oid = 0
Previous Message Bruce Momjian 1999-06-23 19:05:04 Re: [GENERAL] ERROR: typeidTypeRelid: Invalid type - oid = 0

Browse pgsql-sql by date

  From Date Subject
Next Message Zalman Stern 1999-06-24 01:15:16 Re: [SQL] Re:Create table doesn't always respect atomicity of transactions
Previous Message Mark Dalphin 1999-06-23 16:35:40 Re:Create table doesn't always respect atomicity of transactions