Converting Date into Oracle SQL timestamp using Netbeans 6.1

[Wade Chandler]

Check out the JDBC specifications. The easiest way for cross DBMS date time etc and some other functions is using the literal escape syntax if you mean at the DB query level. Oracle's date format is nothing like ISO, at least pre 10g (if it even supports ISO dates yet), so I tend to use { ts 'yyyy-mm-dd hh:mm:ss' } where the place holders are self explanatory. At least it sounds like this is what you are asking...maybe I'm wrong. Anyways, the specifications can be downloaded at:
http://java.sun.com/products/jdbc/download.html

Just get the version you need.

Wade

==================
Wade Chandler, CCE
Software Engineer and Developer, Certified Forensic Computer Examiner, NetBeans Dream Team Member, and NetBeans Board Member
http://www.certified-computer-examiner.com
http://wiki.netbeans.org/wiki/view/NetBeansDreamTeam
http://www.netbeans.org



----- Original Message ----

[HASSAN Kamrul]

I have a calendar control to select date, after selected date I need to
send this date to Oracle SQL (as Epoch time) query (dataProvider).
Could you tell me how I can do this in Java code.

Here is excerpt of my code: output window shows Error as
"sourceId=form1:calendar1[severity=(ERROR 2), summary=(form1:calendar1:
'11/03/2008' could not be understood as a date.),
detail=(form1:calendar1: '11/03/2008' could not be understood as a date.
Example: Nov 20, 2008 )]"

import com.sun.rave.faces.converter.SqlTimestampConverter;

private SqlTimestampConverter calendar1Converter = new
SqlTimestampConverter(); public SqlTimestampConverter
getCalendar1Converter() {
return calendar1Converter;
}
public void setCalendar1Converter(SqlTimestampConverter stc) {
this.calendar1Converter = stc;
}
public void prerender() {
}
public String button1_action() {
if (calendar1.getSelectedDate() != null) {
try {
System.out.printf("\nTesting value is " +
calendar1.getSelectedDate().toString() + "\n");

[HASSAN Kamrul]

Thank you, Wade,

I am using followings in my project.

IDE : Netbeans 6.1 on Java EE 5
Server: Apache Tomcat 6.0.16 (in my PC on Windows XP)
Oracle : 9i
So, user will a date from the calendar Icon (say stored into String
dateSTR),
then I need to use dateSTR as part of query's conditional clause
(to Oracle 9i).
Please tell how can I convert "dateSTR" to Oracle SQLtimestamp so that I
can use it for query.

Sorry! Did not quite follow, what you would want to me to download from
below link, Is there a plug-ins in Netbeans 6.1

Thanks
kam

-----Original Message-----
From: Wade Chandler [mailto:address-removed]
Sent: Friday, November 21, 2008 12:33 AM
To: address-removed
Subject: Re: [nbj2ee] Converting Date into Oracle SQL timestamp using
Netbeans 6.1

Check out the JDBC specifications. The easiest way for cross DBMS date
time etc and some other functions is using the literal escape syntax if
you mean at the DB query level. Oracle's date format is nothing like
ISO, at least pre 10g (if it even supports ISO dates yet), so I tend to
use { ts 'yyyy-mm-dd hh:mm:ss' } where the place holders are self
explanatory. At least it sounds like this is what you are asking...maybe
I'm wrong. Anyways, the specifications can be downloaded at:
http://java.sun.com/products/jdbc/download.html

Just get the version you need.

Wade

==================
Wade Chandler, CCE
Software Engineer and Developer, Certified Forensic Computer Examiner,
NetBeans Dream Team Member, and NetBeans Board Member
http://www.certified-computer-examiner.com
http://wiki.netbeans.org/wiki/view/NetBeansDreamTeam
http://www.netbeans.org



----- Original Message ----