MySQL Date Queries (Changes/Reports)
I have been putting the Scheduled End Time as 31/03/2012 23:59 for many of my changes to denote that they are to be completed within the next Financial Year, however when I report on these the date is displayed as 01-04-12
I'm formatting the date as follows: DATE_FORMAT(FROM_UNIXTIME(chdt.scheduledEndtime/1000),'%d-%m-%y') "FinishDate")
Any help would be appreciated
Running ServiceDesk 8.0 build 8007
MySQL