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:
Parameter | Description |
---|---|
Timestamp expression | an 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".