I am looking for assistance in a sql query in MS Access 2007.
I have imported a table into access. One of the columns is a column called DTG_LOCAL (which is short for Date/time group local time). This column is a string column with the format DDMMMYYYY:HH:MM:SS or 01JAN2010:13:40:00.
I am looking for a sql query that will take the string DTG_LOCAL column and break out DDMMMYYYY and HH:MM to their own columns with an additional column with just HH for a total of three new columns with the broken out information. The three columns would be DATE, TIME, and HOUR; Lastly, convert the columns from a text column to DATE/TIME respectively.
DTG_LOCAL --> DATE / TIME / HOUR or
01JAN2010:13:40:00 --> 01JAN2010 / 13:40:00 / 13
The other columns in the file are not deleted.
The table name is GPS_AI_Import.
Thank you for any assistance,