Is there a way to EXPORT dates and always get yyyy format?

Posted by S33 on 08-Jan-2020 15:32

When I export a record with date fields, is there a way to force dates in that record to always be in the mm/dd/yyyy (4-digit year) format? (I assume it's abbreviating when possible, based on the current -yy parameter.)

Example:

def temp-table tt no-undo
    field dt1 as date format '99/99/9999'
    field dt2 as date format '99/99/9999'
    .

create tt. update tt.
output to /tmp/x.
export tt.
output close.

My input:

dt1        dt2

12/31/2020 04/01/1066

Contents of output:

12/31/20 04/01/1066

 

The problem is that if the -yy is different when the record is later imported, I might not get what I expect.

This is in 10.2b08 on RHEL.

Posted by Neil Treeby on 08-Jan-2020 15:39

Use the -yr4def client start up parameter.

documentation.progress.com/.../

All Replies

Posted by Neil Treeby on 08-Jan-2020 15:39

Use the -yr4def client start up parameter.

documentation.progress.com/.../

Posted by S33 on 08-Jan-2020 21:11

Sounds like exactly what I need. I'll test it. Thanks !

This thread is closed