5 Replies Latest reply on Oct 7, 2009 5:15 PM by comment_1

    Converting MYSQL Timestamp to readable date in filemaker via ess dsn link

    jonnyt

      Title

      Converting MYSQL Timestamp to readable date in filemaker via ess dsn link

      Post

      I have an orders table on my website that has a createdDate timestamp to identify when the sale was made.

       

      The website is made using virtuemart and looking at the datatype for the cdate colum it says it is an integer datatype.

       

      I need to convert this in filemaker using a calculation so that the timestamp displays in readable UK format DD/MM/YYYY hh:mm:ss

       

      Some examples of the data in that column is:-

       

      1253870376

      1253875556

      1254300314

       

       

      Can anyone help?

       

      i think i need to use a let calculation but im not sure what I need to do from there.