hello 2009/3/10 Venkat Rao Tammineni <vtammineni@xxxxxxxxxxxxxxxx>: > Dear All, > > > > > > 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. > > > use function to_date, please http://www.postgresql.org/docs/8.3/static/functions-formatting.html postgres=# select to_date('2009-07-17', 'YYYY-MM-DD'); to_date ---------- 2009-07-17 (1 row) regards Pavel Stehule > > > > > ?Thanx & Regards > > Venkat Rao Tammineni > > GIS Developer > > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
