<div>
Hi virendra. Two months ago i wrote some java code for date fields accesing. JDBC-ODBC return date and time Access format like &quot;java.sql.Timestamp&quot;. Here u have an example: 
 
.... 
Object dateField = r.getObject(column); 
.... 
int myDay &nbsp;= Integer.parseInt(dateField.toString().substring(0,2)); 
int myMonth &nbsp;= Integer.parseInt(dateField.toString().substring(3,5)); 
int myYear = Integer.parseInt(dateField.toString().substring(6,8)); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
// ie2k &nbsp; &nbsp; 
if (myYear &lt;&nbsp;30) 
&nbsp; myYear = myYear+2000; 
else 
&nbsp; myYear = myYear+1900; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
// Timestamp: yyyy-mm-dd hh:mm:ss.fffffffff 
Timestamp myDate = Timestamp.valueOf(myYear+&quot;-&quot;+myMonth+&quot;-&quot;+myDay+&quot; 00:00:00.000000000&quot;); 
.... 
 
Bye... :)
</div>

Hi virendra. Two months ago i wrote some java code for date fields accesing. JDBC-ODBC return date and time Access format like "java.sql.Timestamp". Here u have an example:

....
Object dateField = r.getObject(column);
....
int myDay  = Integer.parseInt(dateField.toString().substring(0,2));
int myMonth  = Integer.parseInt(dateField.toString().substring(3,5));
int myYear = Integer.parseInt(dateField.toString().substring(6,8));
         
// ie2k    
if (myYear < 30)
  myYear = myYear+2000;
else
  myYear = myYear+1900;
           
// Timestamp: yyyy-mm-dd hh:mm:ss.fffffffff
Timestamp myDate = Timestamp.valueOf(myYear+"-"+myMonth+"-"+myDay+" 00:00:00.000000000");
....

Bye... :)

<div>
<div class="content wysiwyg-content">
I am getting a date from date field in MsAccess in a format of date and time(2000-01-12 12:03:45). Please write how to convert this to a display format of 01-Dec-2000. 
 
Thank You, 
 
Virendra 

</div>
</div>

I am getting a date from date field in MsAccess in a format of date and time(2000-01-12 12:03:45). Please write how to convert this to a display format of 01-Dec-2000.

Thank You,

Virendra


Displaying Date from MsAccess to a general format

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.