return date in expression builder

nadavw

<p>Hi,</p><p> </p><p>I'm tring to do the following in order to return a date in a computed column of a date based on milliseconds as an input set:</p><p> </p><p>this is the expression:</p><p> </p><p><strong>[font="'courier new', courier, monospace;"]<span style="font-size:14px;">new Date().setTime([/font]<span style="font-size:14px;">row["value"]</span><span style="font-size:14px;">)</span></span></strong></p><p> </p><p>#row["value"] is miliseconds, i.e. : 1162684800000</p><p> </p><p>I get an error:</p><p><strong>[font="'courier new', courier, monospace;"]<span style="font-size:14px;">Can not convert the value of 1.1626848E12 to java.sql.Date type.[/font]</span></strong></p><p> </p><p>any idea?</p><p> </p><p>thanks,</p><p>Nadav</p>

micajblock

<p>What is the data type of "value"?</p><p> </p><p><a data-ipb='nomediaparse' href='http://stackoverflow.com/questions/17371302/new-datemilliseconds-returns-invalid-date'>http://stackoverflow.com/questions/17371302/new-datemilliseconds-returns-invalid-date</a></p&gt;