Timestamp format must be yyyy-mm-dd[.fffffffff]

peraka

Hi All,

I'm trying to separate date & time from timestamp field. In database it's working fine. When I put the same query in Open method and try to "preview results" from Dataset, it throws error as below.

"Timestamp format must be yyyy-mm-dd[.fffffffff]"

in open method I have given as:

substr(reportdate,1,10) as datereported,
substr(to_char(reportdate,'mm/dd/yyyy, hh:mm:ss'),11)

Thanks,
Suresh.

peraka

<blockquote class='ipsBlockquote' data-author="'peraka'" data-cid="85250" data-time="1321256593" data-date="14 November 2011 - 12:43 AM"><p>
Hi All,<br />
<br />
I'm trying to separate date & time from timestamp field. In database it's working fine. When I put the same query in Open method and try to "preview results" from Dataset, it throws error as below. <br />
<br />
"Timestamp format must be yyyy-mm-dd[.fffffffff]"<br />
<br />
in open method I have given as: <br />
<br />
substr(reportdate,1,10) as datereported,<br />
substr(to_char(reportdate,'mm/dd/yyyy, hh:mm:ss'),11)<br />
<br />
Thanks,<br />
Suresh.<br /></p></blockquote>
<br />
I'm able to get the Date & Time now...used getString("datereported") in fetch method. <br />
<br />
Thanks.