Patrice Hédé wrote:
> Forget my first reply, there is no date(text) function either...
Yes, I know. I thought pg would automagically cast to 'unknown'
when it could not find a valid conversion, and then try again.
Perhaps that could solve many problems.
> But you can do that :
> test=> select test, (test+19000000)::text::datetime::date from testint;
> test| date
> (3 rows)
> The test field is a int4 field, so you can do that (not very nice, but it
> works) :)
> Hope this helps !
Yes! It does. This is exactly what I want! Thank you!
/* m */
In response to
pgsql-general by date
|Next:||From: Aleksey Dashevsky||Date: 1998-06-24 09:13:21|
|Subject: Re: [GENERAL] datatype questions|
|Previous:||From: Christian Steindl||Date: 1998-06-24 06:56:09|
|Subject: Re: [GENERAL] ODBC Failure (fwd)|