Xref: alice comp.databases.oracle.server:65900
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!newsfeed.nacamar.de!rz.uni-karlsruhe.de!blackbush.xlink.net!news.pop-stuttgart.de!wwwi.s.sligos.de!not-for-mail
From: "Michael Mehling" <m.mehling@atos-group.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: Question about SYSDATE
Date: Wed, 15 Sep 1999 14:48:58 +0100
Organization: ATOS Newsserver
Lines: 11
Message-ID: <7ro52i$8tv$1@news.pop-stuttgart.de>
References: <7ro1ps$1vp$1@keeks.cyber.ee>
X-Trace: wwwi.s.sligos.de 937399201 25696 193.16.188.152 (15 Sep 1999 12:40:01 GMT)
X-Complaints-To: news@wwwi.s.sligos.de
NNTP-Posting-Date: 15 Sep 1999 12:40:01 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211

Nothing is wrong. Oracle stores date in your required format! Query the date
as follows:
>> select to_char(yyy,'DD-MM-YYYY HH24:MI:SS') from xxx;
and you will get the result.
Yours
mm
Erkki Arus <aphex@spin.ee> schrieb in im Newsbeitrag:
7ro1ps$1vp$1@keeks.cyber.ee...
>