Automatically Supported Date, Timestamp and Number Formats

During the data upload process the following date, timestamp and number formats are automatically parsed and passed to the database.

Automatically Supported Date Format Masks

'MM/DD/RRRR'

'DD/MM/RRRR'

'DD/MM/RR'

'fmMM/DD/RRRR'

'fmDD/fmMM/RRRR'

'RRRR.MM.DD.'

'DD-MM-RR'

'DD.MM.RRRR'

'DD/MON/RR'

'RRRR-MM-DD'

'DD-MM-RRRR'

'fmDD/MM/RRRR'

'RRRR/MM/DD'

'DD.MM.RR'

'fmRRRR/MM/DD'

'fmDD.MM.RRRR'

'MM/DD/RRRR'

'RRRR.MM.DD'

'fmDD-MM-RRRR'

'RRRR-MM-DD"T"hh24:mi:ss'

Automatically Supported Timestamp Format Masks

'DD/MM/RR HH24.MI.SSXFF'

'DD.MM.RR HH:MI:SSXFF PM'

'DD/MM/RR HH:MI:SSXFF PM'

'DD-MON-YYYY HH24:MI'

'DD-MON-YYYY HH24.MI.SSXFF'

'DD-MON-YYYY HH:MI:SSXFF PM'

'DD-MON-YYYY HH24:MI TZR'

'DD-MON-YYYY HH24.MI.SSXFF TZR'

'DD-MON-YYYY HH.MI.SSXFF PM TZR'

Automatically Supported Number Format Masks

'FML999G999G999G999G990D00'

'999G999G999G999G990D00'

'999G999G999G999G990D0000'

'999G999G999G999G999G999G990'

'999G999G999G999G990D00MI'

'S999G999G999G999G990D00'

'999G999G999G999G990D00PR'