Home » SQL & PL/SQL » SQL & PL/SQL » Timestamp
icon5.gif  Timestamp [message #273823] Thu, 11 October 2007 16:22 Go to next message
kham2k
Messages: 34
Registered: May 2007
Member
Hello All,

I want to find out is there any way we have have timestamp detail more then seconds?


SQL> select sysdate from dual;

SYSDATE
------------------------------------
10/11/2007 14:20:17



Is there any way i can have milli-sec or nano-sec?

Thanks for your help
Re: Timestamp [message #273824 is a reply to message #273823] Thu, 11 October 2007 16:35 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SELECT SYSTIMESTAMP FROM DUAL;
icon4.gif  Re: Timestamp [message #273833 is a reply to message #273824] Thu, 11 October 2007 18:49 Go to previous messageGo to next message
kham2k
Messages: 34
Registered: May 2007
Member
i tried to select around 18,000 records but i dnt see it changing



select systimestamp from mar2.vendor

SYSTIMESTAMP
---------------------------------------------
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
.
.
.
.
.
.
.
.

SYSTIMESTAMP
---------------------------------------------
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00
11-OCT-07 04.47.02.053376 PM -07:00

18810 rows selected.


Re: Timestamp [message #273834 is a reply to message #273823] Thu, 11 October 2007 18:56 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
It works for me.
16:55:51 SQL> SELECT SYSTIMESTAMP FROM DUAL; 

SYSTIMESTAMP
---------------------------------------------------------------------------
11-OCT-07 04.55.53.122446 PM -07:00

16:55:53 SQL> /   

SYSTIMESTAMP
---------------------------------------------------------------------------
11-OCT-07 04.55.57.479600 PM -07:00

16:55:57 SQL> 
Re: Timestamp [message #273866 is a reply to message #273833] Fri, 12 October 2007 01:17 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SYSTIMESTAMP is called only once in the query then it is used like a variable and does not change.

What is your real purpose? Following the query?

Regards
Michel
Previous Topic: PL/SQL Cursor question
Next Topic: ORA-01790
Goto Forum:
  


Current Time: Sat Dec 10 16:21:34 CST 2016

Total time taken to generate the page: 0.11390 seconds