Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

java- how to get/use current date+time in query to SQL Server database  RSS feed

 
Arvind Ik Chari
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to store the current date+time into a table in SQL Server.

Separately, I also want to query the table (in which date+time was stored) and then obtain the date+time as a string value in format YYYYMMDDHHMMSS.

My program is in Java, and I am basically using a SQL Azure database.
 
fred rosenberger
lowercase baba
Bartender
Posts: 12464
43
Chrome Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well...what have you tried?
 
Arvind Ik Chari
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I haven't tried anything yet-- I thought I would google about my requirement -- I have not had to use SQL Server so far(this is the first time I am storing/retrieving date in SQL Server)...and what I found is that its quite complicated to convert Java date-> SQL date.

I did search around for this requirement on Stack Overflow and CodeRanch-- I searched around for other questions similar to my own-- but the closest match on SO only deals with one part of date+time (not both date and time)

Thanks,
Arvind.
 
Campbell Ritchie
Sheriff
Posts: 54033
130
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you found any JDBC tutorials? They might tell you about your problem. Start here.

I shall try duplicating this question in a databases forum; you might get more attention like that.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!