Sort by DATEMADE but date is in a weird format

  • Resolved Baronvon

    (@baronvon)


    11 years, 1 month ago

    Hi there,

    I’m a major noob and need reports on payments made. The query I run works well (thank you) but the order by “datemade” doesn’t help as the dates listed are in a weird format and I cant tell what the dates actually are.

    Here is an example:
    Datemade
    1360358367

    Please help. I really need to be able to sort by date.

    Thanks!

    https://www.ads-software.com/plugins/elisqlreports/

Viewing 1 replies (of 1 total)
  • Plugin Author Eli

    (@scheeeli)

    Try formatting the date with DATE_FORMAT and FROM_UNIXTIME
    So, if your query starts something like this:
    SELECT Datemade FROM ...

    Then try using something like this:
    SELECT DATE_FORMAT(FROM_UNIXTIME(Datemade), '%Y-%m-%d') AS Datemade FROM ...

    If that is not quite what you are looking for then maybe you can give me an example of the current query you are using and a sample of the data output so that I can make a more educated guess ??

    Aloha, Eli

Viewing 1 replies (of 1 total)
  • The topic ‘Sort by DATEMADE but date is in a weird format’ is closed to new replies.