From: | dustin sallings <dustin(at)spy(dot)net> |
---|---|
To: | John Huttley <john(at)mwk(dot)co(dot)nz> |
Cc: | pgsql-general(at)postgreSQL(dot)org, Bob Kruger <bkruger(at)mindspring(dot)com> |
Subject: | Re: [GENERAL] Date time insertion |
Date: | 1999-06-24 01:26:05 |
Message-ID: | Pine.NEB.4.10.9906231825440.383-100000@mobile |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 24 Jun 1999, John Huttley wrote:
None of this matters in a date field, date != datetime
// 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
// >
// >
//
//
//
--
Principal Member Technical Staff, beyond.com The world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L______________________________________________ and America is watching TV. __
From | Date | Subject | |
---|---|---|---|
Next Message | John Huttley | 1999-06-24 04:44:12 | Limitation |
Previous Message | John Huttley | 1999-06-24 01:14:15 | Re: [GENERAL] Date time insertion |