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

Forums:

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.

Well...what have you tried?

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.

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.