Re: Help reqd: Copying char to date

Поиск
Список
Период
Сортировка
От rjb26@hotmail.losethis.nothere.com
Тема Re: Help reqd: Copying char to date
Дата
Msg-id nreh8uoa7p1da7srb80btljea9jgqbba5f@4ax.com
обсуждение исходный текст
Ответ на Help reqd: Copying char to date  (rjb26@hotmail.losethis.nothere.com)
Ответы Re: Help reqd: Copying char to date  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-sql
On Fri, 08 Mar 2002 12:38:29 +0100, rjb26@hotmail.losethis.nothere.com
wrote:

>Anybody offer some advice please:
>
>I want to copy a char field to a date field. Is there any quick way of
>doing this?
>TIA

Sorry - this was not very clear. I can copy text to a date field; but
actually want to be able to perform the following:

I have a text field (contents: 20020301)
I would like to change the field type to Date, but retain the
contents, but formatted as a date type. Any ideas, suggestions?

TIA


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

Предыдущее
От: jdou12345@aol.com (Jdou12345)
Дата:
Сообщение: Retrieving a ' in an SQL statement?
Следующее
От: jmycr@cs.com
Дата:
Сообщение: 'now' problem