Timestamp to Unix time

[dsusin]

Hello,

I need to create a procedure that returns the records from the last 24 hours. Dates are stored as Timestamps. The simplest way I always do these things is using substractions with unix times, but I haven't seen how to convert timestamps to unix time in Teiid, only the opposite conversion. Can I get unix times from timestamps in Teiid? If not, any alternatives which do not require unnecessary "complicated" algorithms checking the day number, the hour number, if the days are in the same month...

Thanks.

[shawkins]

You can use: timestampdiff(SQL_TSI_HOUR, timestamp, currentTimestamp()) < 24

[dsusin]

Thanks, easier than YEAR() * 365 + DAYOFYEAR(), that was what I was going to do.