SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

hh mm with sysdate in oracle sql

Rajesh123Sep 20 2016 — edited Sep 27 2016

Hi All,

select 'Textfile'||

to_char (sysdate, 'MM') ||'_'||

to_char (sysdate, 'DD') ||'_'||

to_char (sysdate, 'YY')

from dual;

output:

Textfile_09_20_16

expected output:

Textfile_09_20_16_hhmm

hh: hour

mm: minutes.

can you please help me.

Oracle 11.2.4

This post has been answered by Solomon Yakobson on Sep 20 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 19 2016

Added on Sep 20 2016

9 comments

538 views