| Formatting a date [message #365138] |
Fri, 07 April 2000 07:56 |
Dominic Dougherty
Messages: 1
Registered: April 2000
|
Junior Member |
|
|
What is this about setting nls date format.
use this
Assumption the usr_field4 is a date field
-----------start----------
SET HEADING OFF
SET PAGESIZE 0
SET LINESIZE 970
SET COLSEP ""
SET ECHO OFF
SET FEEDBACK OFF
SET FLUSH OFF
SET TERMOUT OFF
set trimspool off
SPOOL c:\1.txt
SELECT user,to_char(sysdate,'mm/dd/yyyy'),user
FROM dual;
SPOOL OFF
---------- end --------------
|
|
|
|
|
|
|
|
| Re: Formatting a date [message #365910 is a reply to message #365909] |
Tue, 14 March 2000 15:42  |
Linda McDowell
Messages: 2
Registered: March 2000
|
Junior Member |
|
|
|
Maybe it's the version of oracle we're on 7.3.2.1. I tried rtrim, it accepts the syntax but I'm still left with the 65 spaces following the date. I got it to work by altering the session set nls_date_format= 'mm/dd/yyyy', but I thought there must be an easier way.
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
