[PLUG] Date Reformatting in Database Table -- DONE

Rich Shepard rshepard at appl-ecosys.com
Thu Oct 8 20:54:21 UTC 2009


On Thu, 8 Oct 2009, Rich Shepard wrote:

>   Is there a practical way to apply sed and/or awk to convert the date
> column above from 7/6/1993 to 1993-06-07?

   Ah, never mind. I exported the table in .csv format, imported it into an
Xess-SE spreadsheet, converted that one column to use the @DATE() formula,
exported the spreadsheet, and the date format was correct for SQL.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863



More information about the PLUG mailing list