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.