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.