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.