Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date and time?
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