Re: RE: JAVA TIMESTAMP

Hi :

1, to_number(to_char(timestamp_col, 'dd'))

SQL> select to_number(to_char(current_timestamp, 'dd')) from dual;

TO_NUMBER(TO_CHAR(CURRENT_TIMESTAMP,'DD'))
------------------------------------------
                                        20

2, extract(day from timestamp_col)

SQL> select extract(day from current_timestamp) from dual;

EXTRACT(DAYFROMCURRENT_TIMESTAMP)
---------------------------------
                               20

Is it what  you want?

Thanks.

Good tools make work easy and improve life quality
-- http://www.dbatools.net

Personal software, life, research and professional Oracle recovery service
-- http://www.anysql.net/en
-- http://www.anysql.net   (Chinese)



From: John Hallas 
Sent: 2007-09-20  18:49:36 
To: oracle.tutorials@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx 
CC: 
Subject: RE: JAVA TIMESTAMP 
Does this page help Deepak
 
http://download-uk.oracle.com/otn_hosted_doc/jdeveloper/904preview/jdbc-javadoc/oracle/sql/TIMESTAMP.html
 



From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of DBA Deepak
Sent: 20 September 2007 11:14
To: oracle-l
Subject: JAVA TIMESTAMP
 
Hi Experts,
 
Is there any built-in SQL function which can convert JAVA Timestamp to Oracle 
TIMESTAMP data type. I need this to partition a table based on the 
TIMESTAMP(JAVA TIMESTAMP). I want to partition based on the DAY OF THE MONTH 
part of the Timestamp. 
 
Any help on this is highly appreciated.


-- 
Regards,

Deepak
Oracle DBA 



BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1 2TW.
Registered in England with company number 2777575.
http://www.bjss.co.uk

Other related posts: