Alter column

From: Mike Ellsworth <nhrcommu(at)rochester(dot)rr(dot)com>
To: Novice Postgresql-list <pgsql-novice(at)postgresql(dot)org>
Subject: Alter column
Date: 2006-08-14 12:00:59
Message-ID: 44E065FB.9040905@rochester.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Good Monday,

Is there a way to convert data type `datetime` into an integer
(unix_timestamp) while doing ALTER COLUMN `column_name` TYPE int4
USING CAST(`column_name` as integer) ...... something like this?

Thanks,
Mike E.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Christoph Frick 2006-08-14 12:06:33 Re: Alter column
Previous Message Richard Broersma Jr 2006-08-14 11:07:36 Re: executing a procedure withing a procedure?