File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

On java.sql.Timestamp and java.sql.Date

 
Bhuvana Bala
Greenhorn
Posts: 10
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all,
Can anybody help me to convert to convert 12-JAN-2000 to timestamp.
Also:
If I declare the date variable as java.sql.Date with the above input I am not able to get the timestamp format
I have declare date as Datetime in SQL SERVER.
In java should I declare as java.sql.Date OR java.sql.Timestamp?
In either way pl. help me with the code.
thanx a lot.
 
Anonymous
Ranch Hand
Posts: 18944
  • 0
  • send pies
  • Quote
  • Report post to moderator
Use getTime() method of java.sql.Date to instantiate java.sql.Timestamp(long time).
 
Bhuvana Bala
Greenhorn
Posts: 10
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by dip ch:
Use getTime() method of java.sql.Date to instantiate java.sql.Timestamp(long time).


Can u please be clear. I tried with it .But I dont get it.
Now I need to convert calendar. to Timestamp.
Calendar c1= Calendar.getInstance();
c1.set(2000,12,32);
java.util.Date d= c1.getDate();
java.sql.Date dt=new java.sql.Date(d.getTime);
Now dt is the sql Date. I need java.sql.Timestamp format.Pl. help
pl. see
Thanx

[This message has been edited by Bhuvana Bala (edited July 24, 2001).]
 
Anonymous
Ranch Hand
Posts: 18944
  • 0
  • send pies
  • Quote
  • Report post to moderator
you need to read java api documentation. java school of this site is also a good place.
corrected code:
java.util.Calendar c1= java.util.Calendar.getInstance();
c1.set(2000,12,32);
java.util.Date d= c1.getTime();
java.sql.Date dt=new java.sql.Date(d.getTime());
(Sorry for late reply - naming convention of the site created problem!!)
bye
DC
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic