Perspective Table with named query data type issue

Hi, I'm using the table component in perspective to show the my named query result, In this my "assign_date" column information not showing the result in correct format.
Actually it need show the date & time.
Please give me some suggestion. Thanks.

  • For each column set columns.x.field to the exact name of the column in props.data.
  • For the assign_date column set,
    columns.x.field : assign_date
    columns.x.render : date
    columns.x.dateFormat : YYYY-MM-DD HH:mm:ss (or whatever you want).

Many of the column properties don't work unless you specify the column's field property.

Thanks!