Convert dd-MON-yyyy to julian date : I want to convert dd-MON-yyyy to Julian date as part of SQL query. It would be of great help if anyone could guide on how to achieve this.

new JulianDate().ConvertToJulian(date1) worked when date1 was in mm/dd/yyyy format. But when date1 is in dd-MON-yyyy format i get the error:

    java.text.ParseException: Unparseable date: "16-Mar-2017"

