With this function you can return all or part of a timestamp as a string. You may select to return only the date, the datetime or the full datetime with fractional seconds. The result is a string with no separator characters.


select infor.timestamp_to_string(datetime_expression,'Date')from dataobject 
select infor.timestamp_to_string(datetime_expression,'Time')from dataobject 
select infor.timestamp_to_string(datetime_expression,'Full')from dataobject

The first parameter is the timestamp value.

The second parameter value is Date to return a date as a string, The Time parameter returns the date and time to the second. The Full parameter returns the datetime with fractional seconds. Note that Date, Time, and Full parameters are case-sensitive and must be enclosed within single quotes.