HELP! TO_CHAR FUNCTION IN SELECT - Oracle7 on Windows 95
From: Harpreet Chawla <chawla_at_niehs.nih.gov>
Date: 1996/04/26
Message-ID: <4lqmfp$67n_at_jeeves.niehs.nih.gov>#1/1
Date: 1996/04/26
Message-ID: <4lqmfp$67n_at_jeeves.niehs.nih.gov>#1/1
I am doing my first project in Oracle. The statement -
SELECT TO_CHAR(col_with_date_datatype, 'mm/dd/yy hh24:mi:ss') "Date and
Time",col_a,col_b FROM table_name WHERE ...;
but has no affect on the display format. Similar examples in Oracle
manuals show proper output. Any help thru posting/e-mail would be
appreciated?
Thanks in advance,
Harpreet
Received on Fri Apr 26 1996 - 00:00:00 CEST