How to use the date in the format of "dd/mm/yyyy" or "dd-mm-yyyy" in DBMaker? (DBMR2773)
Users set DB_DaoFm in dmconfig.ini to control the date output format. Now DBMaker supports the following date formats.
mm/dd/yy
mm-dd-yy
dd/mon/yy
dd-mon-yy
mm/dd/yyyy
mm-dd-yyyy
yyyy/mm/dd
yyy-mm-dd
dd/mon/yyyy
dd-mon-yyyy
dd.mm.yyyy
DBMaker doesn't support "dd/mm/yyyy" or "dd-mm-yyyy", but users can use following way as a workaround.
select CAST(DAYOFMONTH(column_name) AS VARCHAR(10))|| '/'|| CAST(MONTH(column_name) AS VARCHAR(10))|| '/'|| CAST(YEAR(column_name) AS VARCHAR(10)) AS "DATE_FORMATED" from table_name;
Version: DBMaker 5.3.x
Product: Normal/Bundle
Platform: Windows/Linux