Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Arvind Ik Chari
Greenhorn
Posts: 13
  • 0
  • 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
Pie
Posts: 12015
24
Chrome Java Linux
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well...what have you tried?
 
Arvind Ik Chari
Greenhorn
Posts: 13
  • 0
  • 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
Pie
Posts: 47229
52
  • 0
  • 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