| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |