Hi,
I am using oracle 10g database server.
I want to truncated the date from Timestamp.
When i use
TRUNC(I.DUE_DT) function
or
TO_DATE(TO_CHAR(I.DUE_DT,'DD-MON-YY') , 'DD-MON-YY') DUE_DT
it is showing only date without time from timestamp.
But in iReport it is always showing Data & Time.
Alauddin
I am using oracle 10g database server.
I want to truncated the date from Timestamp.
When i use
TRUNC(I.DUE_DT) function
or
TO_DATE(TO_CHAR(I.DUE_DT,'DD-MON-YY') , 'DD-MON-YY') DUE_DT
it is showing only date without time from timestamp.
But in iReport it is always showing Data & Time.
Alauddin
1 Answer:
Posted on October 19, 2006 at 6:40am
Set the text field pattern to the date format you want as output, e.g. "dd-MMM-yy". You can find a pattern reference [url=http://java.sun.com/j2se/1.5.0/docs/api/java/text/SimpleDateFormat.html]....
HTH,
Lucian
HTH,
Lucian
