Re: Question about SYSDATE

From: Erkki Arus <erkki_at_spin.ee>
Date: Fri, 17 Sep 1999 11:42:46 +0300
Message-ID: <7rsuql$m0t$1@keeks.cyber.ee>

> Set the NLS_DATEFORMAT via alter session to your requested format.
>
> Then every date will be displayed in this format.
>

I'm sorry, but I've one more question about this hint. Where I can set, how many characters, numbers, marks or whatever, will be returned? When I set NLS_DATE_FORMAT to 'DD-MM-YYYY HH24:MI:SS' via alter session, then the SELECT SYSDATE FROM DUAL returns only 9 characters like 17-09-199.

I'm not sure, depends it from version of Oracle. However, when so, I use Personal Orcale7 Release 7.3.2.2.1 for Windows NT.

Regards, Erkki Arus
e-mail: erkki_at_spin.ee Received on Fri Sep 17 1999 - 03:42:46 CDT