CABI4::. - BOXI - Web Intelligence - Date Formats - How to change date formats - Como formatar datas

Document created by TMACUL Champion on May 2, 2015Last modified by Flavio_Tamaki on Mar 29, 2017
Version 7Show Document
  • View in full screen mode

DATEFORMAT function [Date and time]


Returns a representing a date expression in the specified format.

FormatDate( datetime-expression, string-expression )


  • datetime-expression   The datetime to be converted.
  • string-expression   The format of the converted date.



The following statement returns the value 18/01/1989 13:12:11

 FormatDate( '1989-01-18 13:12:11', 'dd/mm/yyyy hh:mm:ss' );






Function Reference:

How to use formula to change date and time for... | SCN

Everything you need know about CA Service Desk Date format

CA SDM::. Como usar a formatação de datas para o Brasil?


CABI4::. Summary - BOXI for CA SDM 

CA SDM Oracle convert date - call_req - cr - open_date/close_date 

CABI::. Convertendo Segundos para Horas/minutos 00:00:00 

CABI4::. BOXI How to convert date  



Author: Tiago Macul

Tiago MACUL's Blog