Re: [GENERAL] Date time insertion
От | dustin sallings |
---|---|
Тема | Re: [GENERAL] Date time insertion |
Дата | |
Msg-id | Pine.NEB.4.10.9906231825440.383-100000@mobile обсуждение исходный текст |
Ответ на | Re: [GENERAL] Date time insertion ("John Huttley" <john@mwk.co.nz>) |
Список | 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@mindspring.com> // To: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>; // pgsql-sql@postgreSQL.org <pgsql-sql@postgreSQL.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@spy.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. __
В списке pgsql-general по дате отправления: