I have some files created by an ODBC source that puts out dates like 9/30/2011, 11/1/2003, 2/2/2002. The format is m/d/yyyy. I am trying to import this into a SQL database but the import routines wants all dates to be yyyymmdd format (20110930, 20031101, 20020202 from above).
The date occurs twice per row, variable row length.
Is there a standard for doing this?
Thanks.
The date occurs twice per row, variable row length.
Is there a standard for doing this?
Thanks.