Postgres Pro
Downloads
Home   >   mailing lists

Re: Help reqd: Copying char to date - Mailing list pgsql-sql

From rjb26@hotmail.losethis.nothere.com
Subject Re: Help reqd: Copying char to date
Date
Msg-id nreh8uoa7p1da7srb80btljea9jgqbba5f@4ax.com
Whole thread Raw
In response to Help reqd: Copying char to date  (rjb26@hotmail.losethis.nothere.com)
Responses Re: Help reqd: Copying char to date  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: jdou12345@aol.com (Jdou12345)
Date:
Subject: Retrieving a ' in an SQL statement?
Next
From: jmycr@cs.com
Date:
Subject: 'now' problem