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 _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
