On 10/03/2009 12:07, Venkat Rao Tammineni 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. If the varchar is already in the format you need (yyyy-mm-dd) then you ought to be able just to cast it: '2009-03-10'::date If not, you may need to do some clever things with regular expressions first to get it into this format, and then cast it. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
