Xref: alice comp.databases.oracle.tools:39575
Path: alice!news-feed.fnsi.net!news-FFM2.ecrc.net!newsfeeds.belnet.be!news.belnet.be!nmaster.kpnqwest.net!npeer.kpnqwest.net!EU.net!cern.ch!news
From: Montse COLLADOS POLIDURA <Montse.Collados@cern.ch>
Newsgroups: comp.databases.oracle.tools
Subject: WebDB 2.2. Date format problem?
Date: Fri, 04 Feb 2000 16:07:00 +0100
Organization: CERN
Lines: 14
Message-ID: <389AEB14.52D34CB1@cern.ch>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: sunnews.cern.ch 949676780 3656 (None) 137.138.183.89
X-Complaints-To: news@sunnews.cern.ch
X-Mailer: Mozilla 4.05 [en] (Win95; I)

Hello to everybody,

Creating a Report: 
    One of the fields in the select clause has a date datatype.
    I would like to get it in the following format : 
	'DD-MON-YYYY  HH24:MI:SS'
    I have specified this format in the Format Mask field in the Column Formatting of the Report but the time is allways 00:00:00. If I do the same select in a SQL session, I get different times...

I don't see why!! Am I doing sth wrong? Am I forgetting sth?

Any help will be welcome,
Thank you very much in advance.
Montse Collados Polidura
CERN - Switzerland.