Unix Timestamp conversion to dateTime in Crystal reports problem
Posted on 2004-04-20
I am using mysql database and I am storing dates/times as unix timestamps (number of seconds since unix epoch, 1974?). Anyways I am trying to convert these dates back into month, day, year hh:mm:ss format in crystal reports. All the crystal report formula subroutines expect another data type than a unix timestamp, how would I go about getting them into the correct format?