Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL time format Q
"melned" <uncle_melned_at_yahoo.com> wrote in
news:1113179212.597976.288510_at_o13g2000cwo.googlegroups.com:
> I'm attempting to insert a julian time stamp into a table using PL/SQL.
> I'm able to alter my session such that SYSDATE output is julian in a
> select statement:
>
> alter session set NLS_DATE_FORMAT = 'J';
>
> Session altered.
>
> select SYSDATE from dual;
>
> SYSDATE
> -------
> 2453471
>
>
> When I attempt to insert this value, I end up with a 'DD-MMM-YY' format
> such as '10-APR-05'. The column into which I'm attempting to insert is
> of type DATE.
>
>
> alter session set NLS_DATE_FORMAT = 'J';
>
> INSERT into <table name>
> VALUES ( SYSDATE )
>
>
> Any pointers on where I've gone wrong would be greatly appreciated.
>
alter session set NLS_DATE_FORMAT = 'J'; impacts the output/display (ONLY) of DATE datatypes;
What exactly are you doing & what answer do you want? What make you think you have a problem? Received on Sun Apr 10 2005 - 20:01:58 CDT