SAP Knowledge Base Article - Preview

3101035 - How to export data from IQ using a specific date / time format - SAP IQ

Symptom

How to export date / time data with a specific format:

For example:

  • A simple select:

    select * from test_date
    a
     ----------------------------------
          Sep 23 2021  6:48:23.085284PM

  • However, exported it returns:

    SET TEMPORARY OPTION Temp_Extract_Name1 = '/work/iqdates';
    select *from test_date;

    cat /work/iqdates
    2021-09-23 18:48:23.085,


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.