How we can avoide from error Timestamp format must be YYYY-MM-DD HH-MM-SS[.FFFFFFFFF] when date-time input has no any date-time value?

Question

I'm new in Java, i use Java with OFBiz, i have a search form that has date-time input field for searching, when no date-time is selected and form submitted, in Java follow error occur:

Timestamp format must be YYYY-MM-DD HH:MM:SS[.FFFFFFFFF]

So how i can avoid from this? bellow is my code block:

String sDate = request.getParameter('sdate_field');
if(sDate != null)
{
     condition = new EntityXpr("crt_date",Operator.LESS_THAN_EQUAL_TO,Timestamp.valueOf(sDate));
}

Change `if(sDate != null)` to `if(!"".equals(sDate)` :) – Rong Nguyen Feb 13 '15 at 06:15 — Rong Nguyen, Feb 13 '15 at 06:15

score 1 · Answer 1 · answered Feb 19 '15 at 07:18

1

In OFBiz you can do

if (UtilValidate.isNotEmpty(userLogin)) {
    condition = new EntityXpr("crt_date",Operator.LESS_THAN_EQUAL_TO,Timestamp.valueOf(sDate));
}

See org.ofbiz.base.util.* for more convenience methods.

answered Feb 19 '15 at 07:18

Michael Brohl

782
5
21

How we can avoide from error Timestamp format must be YYYY-MM-DD HH-MM-SS[.FFFFFFFFF] when date-time input has no any date-time value?

1 Answers1