Can't format String To Date

[Irliyanti Rahmadhani Lubis]

Hello Guys,
I have some problem's here.
I try to convert String dd/MM/yyyy to Date dd/MM/yyyy.
This is my source code :

String tdate = request.getParameter("tdate");
                //Date date = null;
                Date date = new Date();
                if (tdate != null){
                    if (!tdate.equals("")){
                        DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
                        date = dateFormat.parse(tdate);
                        
                        System.out.println("date" + date);
                        List<LtklSubmitInfo> ltklSubmit = (List<LtklSubmitInfo>)ltklSubmitInfoService.getDataByDTrans(date);

But the ouput is:

dateThu Oct 01 00:00:00 ICT 2015

I'm tyring to convert with different source code, but the result is same.

Thanks in advance.

[Martin Bechtle]

Leave your code as it is, then add this line before System.out

String formattedDate = dateFormat.format(date)

Then you can print this one

[Irliyanti Rahmadhani Lubis]

Martin Bechtle wrote:Leave your code as it is, then add this line before System.out

String formattedDate = dateFormat.format(date)

Then you can print this one

So, it change to String. But I need Date in line 10, Martin.

... getDataByDTrans(date)

[Martin Bechtle]

Allright... well a Date object has no format in Java. It only gets a format when it's transformed into a String or parsed from a String. So you have to find where in your code the date gets printed and use the code I gave you there.

[Irliyanti Rahmadhani Lubis]

Martin Bechtle wrote:Allright... well a Date object has no format in Java. It only gets a format when it's transformed into a String or parsed from a String. So you have to find where in your code the date gets printed and use the code I gave you there.

I don't understand that flow.
So, you ask me to add :

String formattedDate = dateFormat.format(date);

in my code.

And then, I make it like:

String tdate = request.getParameter("tdate");
                Date date = new Date();
                if (tdate != null){
                    if (!tdate.equals("")){
                        DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
                        tdate = dateFormat.format(date);
                        System.out.println("date" + date);
                        List<LtklSubmitInfo> ltklSubmit = (List<LtklSubmitInfo>)ltklSubmitInfoService.getDataByDTrans(date);
                    }
                }

I change your

String formattedDate

to my String

tdate 

.
but, because it's String, on the

... .getDataByDTrans(date)

, it's need Date Type. I'm making it to

...getDataByDTrans()

So, I add the

...getDataByDTrans(java.sql.Date.valueOf(tdate)

The result, it's Error.


Actually, I want to SELECT data by Date.
In the table of DB, the type Date is Date (MM/dd/yyyy).

and I use Native SQL in My Hibernate, like :

@Override
       public List<LtklSubmitInfo> loadDataByDTrans (Date dAwal){
       String SQL = "SELECT a.ZIP_FILE_NAME, a.LTKL_COUNT, a.LTKL_COUNT_PROCESS, b.STATUS, a.SENT_DATE, a.RECEIVE_DATE" +
                    " FROM T_LTKL_SUBMIT_INFO a" +
                    " JOIN T_LTKL_SUBMIT_INFO_DET b" +
                    " ON a.ID = b.ID" +
                    " JOIN T_KUPU_IN c" +
                    " ON b.NO_LTKL = c.NO_LTKL" +
                    " JOIN T_KUPU_IN_TRANSAKSI d" +
                    " ON c.ID_KUPU_INCOMING = d.ID_KUPU_INCOMING" +
                    " WHERE b.STATUS = 1" +
                    " AND d.D_TRANSAKSI =:D_TRANSAKSI";
       
       SQLQuery query = getSession().createSQLQuery(SQL);
       
       //query.setString("d_transaksi", "Some value with : in it");
       query.setDate("D_TRANSAKSI", dAwal);
       //query.addEntity(LtklSubmitInfo.class);
       query.addEntity("ZIP_FILE_NAME", LtklSubmitInfo.class);
       query.addEntity("LTKL_COUNT", LtklSubmitInfo.class);
       query.addEntity("LTKL_COUNT_PROCESS", LtklSubmitInfo.class);
       query.addEntity("SENT_DATE", LtklSubmitInfo.class);
       query.addEntity("RECEIVE_DATE", LtklSubmitInfo.class);
       query.addEntity("STATUS", LtklSubmitInfoDetail.class);
       query.addEntity("ID", LtklSubmitInfoDetail.class);
       query.addEntity("ID_KUPU_INCOMING", TKupuIncoming.class);
       query.addEntity("ID_KUPU_INCOMING", TKupuIncomingTransaksi.class);
       
      // query.setParameter("D_TRANSAKSI", D_TRANSAKSI);
       //query.setParameter("D_TRANSAKSI", dAwal);
       //query.setParameter("D_TRANSAKSI", dAwal, TemporalType.DATE);
       
       return query.list();
       }

My Service source code, is:

public List<LtklSubmitInfo> getDataByDTrans(Date dAwal){
        return ltklSubmitInfoDao.loadDataByDTrans(dAwal);
    }

and the format date is my Controller.

I'm not yet found to solved that.

[Irliyanti Rahmadhani Lubis]

Martin Bechtle wrote:Allright... well a Date object has no format in Java. It only gets a format when it's transformed into a String or parsed from a String. So you have to find where in your code the date gets printed and use the code I gave you there.

Okay, I got it what you mean, Martin.
So you want me to convert that String To Date and to String again? so it can be like dd/MM/yyyy format.
Hem, I there's another way to make it still "Date". Because, I want Date.