Skip Headers
Oracle® Application Express End User's Guide
Release 4.2

E35124-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
PDF · Mobi · ePub

4.4 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'