2009/3/10 Jaume Sabater <jsabater@xxxxxxxxx>: > On Tue, Mar 10, 2009 at 1:07 PM, Venkat Rao Tammineni > <vtammineni@xxxxxxxxxxxxxxxx> wrote: > >> I have one table which has lot of data.In the same table I have one >> varchar filed. I want to convert into Date data type? Is It possible to >> convert varchar to date datatype with out loosing data.Please guide me.I am >> waiting for your great response. > > An easy solution would be to add a new column to the table, of type > date, and then execute an update statement that reads, for each row, > the value in the varchar field and writes the converted value to the > date field. > resp. alter table someatb alter column columname type date using to_data(columname, 'YYYY-MM-DD'); regards Pavel > -- > Jaume Sabater > http://linuxsilo.net/ > > "Ubi sapientas ibi libertas" > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
