Which date format is supported by DBMaker? (DBMR2485)
DBMaker supports following date format:
- Input Format: mm/dd/yy, mm-dd-yy, dd/mon/yy, dd-mon-yy, mm/dd/yyyy, mm-dd-yyyy, yyyy/mm/dd, yyyy-mm-dd, dd/mon/yyyy, dd-mon-yyyy, dd.mm.yyyy.
- Output Format: mm/dd/yy, mm-dd-yy, dd/mon/yy, dd-mon-yy, mm/dd/yyyy, mm-dd-yyyy, yyyy/mm/dd, yyyy-mm-dd, dd/mon/yyyy, dd-mon-yyyy, dd.mm.yyyy.
The UDF function TO_DATE is used to convert a selected string into any DATE format listed above. Meanwhile, if want to display the date in the format mm/yy, users can use the following statement.
SELECT CAST(MONTH(DT_INI) AS VARCHAR(10)) || '/' || CAST(YEAR(DT_INI) AS VARCHAR(10)) AS "DATE_FORMATED" FROM table_name
Version: DBMaker5.2.x
Product: Normal/Bundle
Platform: Windows/Linux