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.

Syntax
FormatDate( datetime-expression, string-expression )
Parameters

 

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

 

Example

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' );

 

 

date-formats_macul.png

 

 

Function Reference:

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

Everything you need know about CA Service Desk Date format

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

 

---------------------------------

3 people found this helpful

Attachments

    Outcomes