Date time insertion

Поиск
Список
Период
Сортировка
От Bob Kruger
Тема Date time insertion
Дата
Msg-id 3.0.5.32.19990623140654.007d9d60@mindspring.com
обсуждение исходный текст
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Mark Dalphin
Дата:
Сообщение: Re:Create table doesn't always respect atomicity of transactions
Следующее
От: Zalman Stern
Дата:
Сообщение: Re: [SQL] Re:Create table doesn't always respect atomicity of transactions