<div>
Bear in mind that sql Date contains no hours, minutes etc.
</div>


Bear in mind that sql Date contains no hours, minutes etc.

<div>
Thanks<br />
<br />
Could I ask if this seems the correct way of returning the day, month, year.<br />
<br />
Calendar calendar = new GregorianCalendar(2006, 0, 1);<br />
java.sql.Date date = new java.sql.Date(calendar.get<wbr />Time().get<wbr />Time());<br />
&nbsp;<br />
And to add the date in a preparedstatement, would I need to use date.toString()?<br />
<br />

</div>


Thanks

Could I ask if this seems the correct way of returning the day, month, year.

Calendar calendar = new GregorianCalendar(2006, 0, 1);
java.sql.Date date = new java.sql.Date(calendar.getTime().getTime());
 
And to add the date in a preparedstatement, would I need to use date.toString()?



<div>
Could I ask finally,<br />
<br />
To return all the records with from march 06 and in ordered on the day. Could we achieve this from the datestamp field, which contains a java.sql.Data value?
</div>


Could I ask finally,

To return all the records with from march 06 and in ordered on the day. Could we achieve this from the datestamp field, which contains a java.sql.Data value?

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Using mysql I set a column datestamp to use the date field type.<br />
<br />
Could anyone advise if I would use the java.sql.Date object to capture the time-clock to add this in the table?<br />
<br />
And having stored the date, would I be-able to query the database datestamp field using a PreparedStatement to return fields with a particular month and year.<br />
<br />
Or to query in this way would I need to have a separate, month and year field in the table?<br />
<br />
Thank you<br />
<br />

</div>
</div>


Hello,

Using mysql I set a column datestamp to use the date field type.

Could anyone advise if I would use the java.sql.Date object to capture the time-clock to add this in the table?

And having stored the date, would I be-able to query the database datestamp field using a PreparedStatement to return fields with a particular month and year.

Or to query in this way would I need to have a separate, month and year field in the table?

Thank you



Adding date to mysql tables?

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.