convert date to time?

From: speeves <speevey(at)cc(dot)admin(dot)unt(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: convert date to time?
Date: 2001-05-18 14:28:49
Message-ID: 9e3bk6$dki$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi!

I am migrating a bunch of cf applications that are using access as a
backend, and pgadmin is converting all date/time data types to date data
types on the postgres side. I want to convert these columns to the
appropriate time data types, but am unable to using CAST( according to the
pop-up window.) Is there another way?

Thanks!
--
Shannon Peevey
UNT-Central Web Support
speevey(at)cc(dot)admin(dot)unt(dot)edu
940-369-7786

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-05-18 15:15:12 Re: Inherited tables: How stable is that feature?
Previous Message Hans-Jürgen Schönig 2001-05-18 13:39:15 Calculating the age of a person