Select date format ddmmyyyy from oracle database

Question

I want to select a date field from oracle database, using select to_date(trndt, 'yyyymmdd') from cf20gldt, but the system was showing an error.

Answer 1

Reference

Change it as to_char

SELECT TO_CHAR(trndt, 'yyyymmdd') FROM cf20gldt;

if your trndt column is not date type then you have to change it as

SELECT TO_CHAR(TO_DATE(trndt), 'yyyymmdd') FROM cf20gldt;

For example display system date

SELECT TO_CHAR(sysdate,'yyyymmdd') FROM dual;

Answer 2

To_date is to convert a column to date format . If your trndt is not date already then use below :

select to_char(to_date(trndt), 'yyyymmdd') from cf20gldt;

Or if your column trndate is already in date format then use below:-

select to_char(trndt, 'yyyymmdd') from cf20gldt;