To Get Time stamp in report

SiddhuShini

<p>Hi,</p><p>i have db column with Date(time stamp) like this format(Thu Dec 19 14:22:19 PST 2013) but in report when do the column mapping with Date or Date Time format only .Please let me know how can I get in Thu Dec 19 14:22:19 PST 2013 format?</p>

bgbaird

<p>Hey,</p><p> </p><p>To use the datapoint as a DT, format it as a custom DT format <EEE MMM dd HH:mm:ss z yyyy>.</p><p> </p><p>if you need to use the DT as a string, here's how I convert it:</p><p>new Packages.java.text.SimpleDateFormat("EEE MMM dd HH:mm:ss z yyyy").format(new Date());</p><p> </p><p>I know the "z" flag works for US time zones, but it may work globally.</p><p> </p><p>Here s a good reference: <a data-ipb='nomediaparse' href='http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html'>http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html</a></p><p> </p><p>Good luck, Brian</p>