Re: does datatype DATE stores fractions of seconds (Oracle8i)?

From: Bronke, Nicolas <newsgroup_at_trinity.de>
Date: Tue, 28 Mar 2000 19:34:22 +0200
Message-ID: <38e10386_1@news2.prserv.net>

> For some reason I have to migrate from Sybase to Oracle. Now it looks
> like that Oracles datatype DATE
> doesn't have fractions of seconds like Sybase DATETIME (04-03-2000
> 09:08:12:587). Is there a way to store
> fractions or do I have to use a workaround like storing the fractions in
> a separate int-column (which is not nice) ?
>

A Date field stores seconds nut it is not displayed standardized.

Look at

select to_char(sysdate,'DD:MM:YY HH24:MI:SS') from dual

regards
Nicolas Received on Tue Mar 28 2000 - 11:34:22 CST

This message: [ Message body ]
Next message: Jonathan Lewis: "Re: SQL update/insert statement."
Previous message: Connor McDonald: "Re: EXISTS/NOT EXISTS vs. IN/NOT IN"
In reply to: Carsten Jacobs: "does datatype DATE stores fractions of seconds (Oracle8i)?"
Next in thread: Finn Ellebaek Nielsen: "Re: does datatype DATE stores fractions of seconds (Oracle8i)?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US