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 for Me (Login required).

Search for additional results

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