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: PL/SQL time format Q

Re: PL/SQL time format Q

From: Gump <phefford_at_gmail.com>
Date: 10 Apr 2005 19:17:01 -0700
Message-ID: <1113185821.237881.86840@f14g2000cwb.googlegroups.com>


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

Original text of this message

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