oracle, 10, database, using carriage return

folks,how can i use oracle to define a carriage return of a date field

my field is reportdate  13-06-2008 14:25:02 and i want the field to display

reportdate
13-06-2008
14:25:02

im hesitant of it working but all help will do

r
rutgermonsAsked:
Who is Participating?
 
johnsoneConnect With a Mentor Senior Oracle DBACommented:
select to_char(sysdate, 'dd-mm-yyyy') || chr(10) || to_date(sysdate, 'hh24:mi:ss');
0
 
MilleniumaireCommented:
It depends which tool you are using to display the output.

The following characters will display a newline on a unix system:

chr(13)||chr(10)

For example:

declare
  newline varchar2(2) := chr(13)||chr(10);
begin
  dbms_output.put_line('Line1'||newline||'Line2');
end;
/
0
 
schwertnerCommented:
CHR(10) is enough!
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
rutgermonsAuthor Commented:
example?
0
 
MilleniumaireCommented:
Dug the example out of some code.  Not sure why they use chr 13 and 10, but chr 10 is enough to give a newline as follows:
declare
  newline varchar2(1) := chr(10);
begin
  dbms_output.put_line('Line1'||newline||'Line2');
end;
/
0
 
rutgermonsAuthor Commented:
how do i dump this into a select type query according to my intial question?
0
 
MilleniumaireCommented:
Or, to ensure you get the required heading:

select to_char(reportdate, 'dd-mm-yyyy') || chr(10) || to_date(reportdate, 'hh24:mi:ss') reportdate
from yourtable;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.