Date Format (Urgent)

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

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
--------------------------------------------------------------------------------
Type='News' ChannelId='SE.008QBVK'>
Show 40 post(s) from this thread on one page

Page 2 of 2 First 12

• Jump to page: