Built-in Functions → removeTime

removeTime() is a scalar date function that returns a date value in the format "MM/dd/yy" by removing the time fields from the timestamp value.

Signature

removeTime(Timestamp expression)

The following table illustrates the removeTime() parameter:

ParameterDescription
Timestamp expressionan expression evaluating to timestamp

Returns

string

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".