From: | "John Huttley" <john(at)mwk(dot)co(dot)nz> |
---|---|
To: | <pgsql-general(at)postgreSQL(dot)org>, "Bob Kruger" <bkruger(at)mindspring(dot)com> |
Subject: | Re: [GENERAL] Date time insertion |
Date: | 1999-06-24 01:14:15 |
Message-ID: | 010f01bebdde$e17ce280$1401a8c0@Mr_Creosote.MWK.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I use '1999-04-21 21:23:21' type format with sucess.
Regards
-----Original Message-----
From: Bob Kruger <bkruger(at)mindspring(dot)com>
To: pgsql-general(at)postgreSQL(dot)org <pgsql-general(at)postgreSQL(dot)org>;
pgsql-sql(at)postgreSQL(dot)org <pgsql-sql(at)postgreSQL(dot)org>
Date: Thursday, 24 June 1999 07:07
Subject: [GENERAL] Date time insertion
>
>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 | dustin sallings | 1999-06-24 01:26:05 | Re: [GENERAL] Date time insertion |
Previous Message | Matt Magoffin (Borders Online) | 1999-06-24 01:10:57 | ERROR: Unable to open PostgreSQL large object |