[postgis-users] The use of substring()

[maduako ikechukwu]

Hi guys,

I want to extract date information from the filename column of my raster
table to update a new date_of_creation column

but i don't have an idea of how to do this, using the substring() and
casting it.

Please could someone write for me a sample sql instruction on how this is
done.

Thanks a lot.



-- 
Iyke Maduako

Masters in Geospatial Technologies
Institute for Geoinformatics,IfGI
University of Muenster Germany
Phone: +4915129048460
Alternative Email:iykefirstclass at yahoo.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111023/d3a83c20/attachment.html>