2 Replies Latest reply on Mar 7, 2013 6:21 AM by Daniel Susín

    Timestamp to Unix time

    Daniel Susín Newbie

      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.