The SQL below returns the field ‘TABLE.LAST_DTTM_UPDATE’ in this format: 'YYYY-MM-DD-HH24.MI.SS.FF'.
Example field value: 01/14/2016 1:36:36PM
Unfortunately, I don’t have any way to change this format within the SQL. When I try to import the data into a new table of an Access 2013 database, I would like for this value to be in Date With Time format and not Short Text format. However, I receive errors in Access if I try to specify Date With Time format while importing the csv file via the Import Text Wizard. It will only let me import this field as a Short Text format.
Any ideas on what I can do to convert this field value from Short Text format to Date With Time format within Access 2013?
SQL:
SELECT DISTINCT TABLE.PO_ID, TO_CHAR(TABLE.PO_DT,'YYYY-MM-DD'), TABLE.PO_STATUS, TABLE.CHNG_ORD_BATCH, TO_CHAR(CAST((TABLE.LAST_DTTM_UPDATE) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF')
FROM PS_PO_HDR A
WHERE ( TABLE.CHNG_ORD_BATCH > 0 )
Example field value: 01/14/2016 1:36:36PM
Unfortunately, I don’t have any way to change this format within the SQL. When I try to import the data into a new table of an Access 2013 database, I would like for this value to be in Date With Time format and not Short Text format. However, I receive errors in Access if I try to specify Date With Time format while importing the csv file via the Import Text Wizard. It will only let me import this field as a Short Text format.
Any ideas on what I can do to convert this field value from Short Text format to Date With Time format within Access 2013?
SQL:
SELECT DISTINCT TABLE.PO_ID, TO_CHAR(TABLE.PO_DT,'YYYY-MM-DD'), TABLE.PO_STATUS, TABLE.CHNG_ORD_BATCH, TO_CHAR(CAST((TABLE.LAST_DTTM_UPDATE) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF')
FROM PS_PO_HDR A
WHERE ( TABLE.CHNG_ORD_BATCH > 0 )
