Re: Milliseconds and DATE field

From: John Chiu <johnymc_at_netscape.net>
Date: Mon, 13 Dec 1999 05:30:23 -0500
Message-ID: <832jho$ffc$1@news2.tor.accglobal.net>

O8IB > select to_char(sysdate,'yyyy/mm/dd hh24:mi:ssss') from dual;

TO_CHAR(SYSDATE,'YYYY

---

1999/12/13 05:29:3232

HTH John Chiu

Kim Hellan <khe_at_NOSPAMkmd.dk> wrote in message news:83297r$abt$1_at_news1.tele.dk...
> Does the DATE field in Oracle8 support milliseconds ?
>
> If yes, how do I use SQL to INSERT a record with a date/time value in the
> format 'YYYY-MM-DD hh:mm:ss:uuu', where uuu is the milliseconds ?
>
> If no, is there another field type that supports milliseconds (like the
> DateTime field in an MS SQL Server) ?
>
> TIA
> Kim Hellan
>
>
Received on Mon Dec 13 1999 - 04:30:23 CST