Date Format (Urgent)

[chrisrlong]

Case-in-point. This is precisely what you do *not* want to do. Never wrap the column in a function if you can at all avoid it.

- Chris

[dragon99]

Hi, Sonaliak, here is the output from your query:
SQL> select xmlbody from messagearchive
2 where trunc(to_date(arrivaltime, 'DD-MM-YY')) = trunc(to_date('19-12-00' , 'DD-MM-YY'))
3 ;

XMLBODY
--------------------------------------------------------------------------------
<Sco
Type='News' ChannelId='SE.008QBVK'>
<CreationTime><Time Iso8601="20001219T

ERROR:
ORA-01801: date format is too long for internal buffer

Is that because of to_date?