Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: date and time?

Re: date and time?

From: Hannes Wenzel <hannes.wenzel_at_telekom.at>
Date: Tue, 29 Dec 1998 07:10:45 +0100
Message-ID: <36887265.B21A1C1B@telekom.at>


Ed Zappulla wrote:
>
> Does anyone know how to get oracle 8.0.4 to display a DATE field with the
> corresponding time as a default?
>
> Also, is it possible to specify a Date field with more precision than
> seconds? I'd like to go to milliseconds.
>
> ...ed

Specify the two variables NLS_DATE_FORMAT and NLS_DATE_LANGUAGE in the unix user profile.

Best regards,
Hannes Received on Tue Dec 29 1998 - 00:10:45 CST

Original text of this message

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