Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL time format Q
Yes, setting the NLS_DATE_FORMAT will affect display only.
You will need to do this...
insert into <table name>
values (to_char(SYSDATE,'J'))
Just be sure you have the correct datatype in the column you are inserting to. Received on Sun Apr 10 2005 - 21:17:01 CDT