var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query on SysDate
I executed the SYSDATE function call in my SQLPLUS, and it displayed the system date with out the time stamp in it.
select sysdate from dual;
even I tried to insert it into my table again the same thing happened, the timestamp is missing.
create table test (col1 date)
insert into test values (sysdate);
Kindly let me know am i missing any system properties to be set
mine is Oracle 9i on Windows XP2
thanks and regards,
Last edited by Shefu; 04-26-07 at
by default a time stamp is displayed using your default nls date format setting. SYSDATE always contains the time element but the default format causes it not to be displayed. If you want to see the timestamp use the following
select to_char(sysdate,'MM/DD/YYYY HH24:MI.SS') FROM DUAL;
You do not need a parachute to skydive. You only need a parachute to skydive twice.
Thanks for the reply, I tried to fetch the data of the above specified sample table from my java program using JDBC drivers. Even then the value of the date is displayed without the TIMESTAMP..
How can the format of the Date can be changed to retrieve the timestamp along with the date?
Check this example:
As you can see, time portion is here.
SQL> create table test (col1 date);
SQL> insert into test values (sysdate);
1 row created.
SQL> select to_char(col1, 'dd.mm.yyyy hh24:mi:ss') date_time from test;
Now do the same on your database and post the result back here. Please, do copy-paste the whole session.