Re: Help reqd: Copying char to date

From: rjb26(at)hotmail(dot)losethis(dot)nothere(dot)com
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Help reqd: Copying char to date
Date: 2002-03-08 13:26:17
Message-ID: nreh8uoa7p1da7srb80btljea9jgqbba5f@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 08 Mar 2002 12:38:29 +0100, rjb26(at)hotmail(dot)losethis(dot)nothere(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message jmycr 2002-03-08 14:13:31 'now' problem
Previous Message Andre Schubert 2002-03-08 12:28:33 REFERENCES