You are viewing content for 5.1 | 5.0 | 4.9 | 4.8 | 4.7 | 4.6 | 4.5 | 4.4 | 4.3 | Previous Releases


removeTime

Returns a timestamp value with the time fields removed, leaving date.

Example

Remove the time component from the timestamp “1/1/00 12:00:00 AM”.

removeTime(INCORTA.EMP.DATE_CREATED)

This example returns the date “1/1/00”.

Syntax

removeTime(timestamp expr t)
  • t : expression evaluating to timestamp

    Returns

    string

Notes

Function removeTime returns the date in the format “MM/dd/yy” from a timestamp value.


© Incorta, Inc. All Rights Reserved.