Oracle DateTime Truncate problem

[alauddinctgbd]

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

[lucianc]

Set the text field pattern to the date format you want as output, e.g. "dd-MMM-yy". You can find a pattern reference here.

 

HTH,

Lucian