title: i have date in form "5/7/2009 6:15:00 PM",
body: <p>Using pig script, how to convert date in form "YYYY-MM-dd" to datetime?</p>
  
  <p>i have tried below but getting error:</p>
  
  <blockquote>
    <p>Could not infer the matching function for org.apache.pig.builtin.CONCAT as multiple or none of them fit. Please use an explicit cast.</p>
  </blockquote>
  
  <pre><code>bill_details= FOREACH filter_bill_details GENERATE $0 AS invD_icode, $1 AS invD_InvH_icode, $2 AS invD_InvH_No, ToDate($3, ' M/dd/yyyy hh:mm:ss aa') AS invD_InvH_date,$5 AS invD_pro_icode,
  $6 AS invD_pro_ucode, $7 AS invD_pro_name,  $8 AS invD_qty;
  
  date_check= foreach bill_details generate
  CONCAT(CONCAT(CONCAT(GetYear(invD_InvH_date),'-')),(CONCAT(GetMonth(invD_InvH_date),'-')),GetDay(invD_InvH_date))  AS invD_InvH_date;
  </code></pre>