DateTime in to database

DateTime in to database

View Answers

June 26, 2009 at 11:35 AM

Hi Friend,

To insert the date,use the following code in your application:

java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());
<%
----------------
-------------------
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connection = DriverManager.getConnection("jdbc:odbc:access");
Statement statement = connection.createStatement();
String DateOut="29/06/2009";

String sql = ("INSERT INTO View_Service VALUES ('"+ ServiceNo + "','" + dt + "','" + Dateout + "','" + UserName + "','" + CabinetSerialNo + "','" + Department + "','" + Sub_Dept + "','"+ Issue +"','"+ Remark +"','"+ SlNo_ForNew +"','"+ Problem_Code +"','" + Problem_Solved + "')");
statement.executeUpdate(sql);
out.println("Data is inserted into the database");
statement.close();
connection.close();
*>

Thanks

June 26, 2009 at 11:36 AM

Hi Friend,

To insert the date,use the following code in your application:


<%
java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());
----------------
-------------------
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connection = DriverManager.getConnection("jdbc:odbc:access");
Statement statement = connection.createStatement();
String DateOut="29/06/2009";

String sql = ("INSERT INTO View_Service VALUES ('"+ ServiceNo + "','" + dt + "','" + Dateout + "','" + UserName + "','" + CabinetSerialNo + "','" + Department + "','" + Sub_Dept + "','"+ Issue +"','"+ Remark +"','"+ SlNo_ForNew +"','"+ Problem_Code +"','" + Problem_Solved + "')");
statement.executeUpdate(sql);
out.println("Data is inserted into the database");
statement.close();
connection.close();
%>

Thanks









Related Tutorials/Questions & Answers:
DateTime in to database - Development process
DateTime in to database  Hi, can u give me jsp code for inserting Date and Time in ti database. Not seperately. Thanks Prakash... + "')"); statement.executeUpdate(sql); out.println("Data is inserted into the database
comparision between database's datetime field and systemdate of java application - Java Beginners
comparision between database's datetime field and systemdate of java application  Hi All, I have a database table which contains datetime... finding the date difference between database's datetime field and systemdate
Advertisements
ModuleNotFoundError: No module named 'DateTime'
ModuleNotFoundError: No module named 'DateTime'  Hi, My Python... 'DateTime' How to remove the ModuleNotFoundError: No module named 'DateTime... to install padas library. You can install DateTime python with following
Version of taglibs>datetime dependency
List of Version of taglibs>datetime dependency
database
database  database
database
database  database application
database
database  the code for initializing the database connection
Version of taglibs>datetime-doc dependency
List of Version of taglibs>datetime-doc dependency
Version of taglibs>datetime-examples dependency
List of Version of taglibs>datetime-examples dependency
Version of com.cogpp>datetime-generator_2.11 dependency
List of Version of com.cogpp>datetime-generator_2.11 dependency
database
database  i want to let the user select the name of database and then delete that database.......im doing project in swings netbeans
ModuleNotFoundError: No module named 'datetime-quarter'
ModuleNotFoundError: No module named 'datetime-quarter'  Hi, My... named 'datetime-quarter' How to remove the ModuleNotFoundError: No module named 'datetime-quarter' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'datetime_truncate'
ModuleNotFoundError: No module named 'datetime_truncate'  Hi, My... named 'datetime_truncate' How to remove the ModuleNotFoundError: No module named 'datetime_truncate' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'datetime_truncate'
ModuleNotFoundError: No module named 'datetime_truncate'  Hi, My... named 'datetime_truncate' How to remove the ModuleNotFoundError: No module named 'datetime_truncate' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'datetime_utils'
ModuleNotFoundError: No module named 'datetime_utils'  Hi, My... named 'datetime_utils' How to remove the ModuleNotFoundError: No module named 'datetime_utils' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'format_datetime'
ModuleNotFoundError: No module named 'format_datetime'  Hi, My... named 'format_datetime' How to remove the ModuleNotFoundError: No module named 'format_datetime' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'format_datetime'
ModuleNotFoundError: No module named 'format_datetime'  Hi, My... named 'format_datetime' How to remove the ModuleNotFoundError: No module named 'format_datetime' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'JSON-Datetime'
ModuleNotFoundError: No module named 'JSON-Datetime'  Hi, My... 'JSON-Datetime' How to remove the ModuleNotFoundError: No module named 'JSON-Datetime' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'micropython-datetime'
ModuleNotFoundError: No module named 'micropython-datetime'  Hi...: No module named 'micropython-datetime' How to remove the ModuleNotFoundError: No module named 'micropython-datetime' error? Thanks   Hi
ModuleNotFoundError: No module named 'pnp-datetime'
ModuleNotFoundError: No module named 'pnp-datetime'  Hi, My Python... 'pnp-datetime' How to remove the ModuleNotFoundError: No module named 'pnp-datetime' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'pnp-datetime'
ModuleNotFoundError: No module named 'pnp-datetime'  Hi, My Python... 'pnp-datetime' How to remove the ModuleNotFoundError: No module named 'pnp-datetime' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'pycopy-datetime'
ModuleNotFoundError: No module named 'pycopy-datetime'  Hi, My... named 'pycopy-datetime' How to remove the ModuleNotFoundError: No module named 'pycopy-datetime' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'pycopy-datetime'
ModuleNotFoundError: No module named 'pycopy-datetime'  Hi, My... named 'pycopy-datetime' How to remove the ModuleNotFoundError: No module named 'pycopy-datetime' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'Spruce-datetime'
ModuleNotFoundError: No module named 'Spruce-datetime'  Hi, My... named 'Spruce-datetime' How to remove the ModuleNotFoundError: No module named 'Spruce-datetime' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 't_datetime'
ModuleNotFoundError: No module named 't_datetime'  Hi, My Python..._datetime' How to remove the ModuleNotFoundError: No module named 't_datetime' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 't_datetime'
ModuleNotFoundError: No module named 't_datetime'  Hi, My Python..._datetime' How to remove the ModuleNotFoundError: No module named 't_datetime' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 't_datetime'
ModuleNotFoundError: No module named 't_datetime'  Hi, My Python..._datetime' How to remove the ModuleNotFoundError: No module named 't_datetime' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 'bits-datetime'
ModuleNotFoundError: No module named 'bits-datetime'  Hi, My... 'bits-datetime' How to remove the ModuleNotFoundError: No module named 'bits-datetime' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'click-datetime'
ModuleNotFoundError: No module named 'click-datetime'  Hi, My... named 'click-datetime' How to remove the ModuleNotFoundError: No module named 'click-datetime' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'datetime-curtis'
ModuleNotFoundError: No module named 'datetime-curtis'  Hi, My... named 'datetime-curtis' How to remove the ModuleNotFoundError: No module named 'datetime-curtis' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'datetime-diff'
ModuleNotFoundError: No module named 'datetime-diff'  Hi, My... 'datetime-diff' How to remove the ModuleNotFoundError: No module named 'datetime-diff' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'datetime-distance'
ModuleNotFoundError: No module named 'datetime-distance'  Hi, My... named 'datetime-distance' How to remove the ModuleNotFoundError: No module named 'datetime-distance' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'datetime-extractor'
ModuleNotFoundError: No module named 'datetime-extractor'  Hi, My... named 'datetime-extractor' How to remove the ModuleNotFoundError: No module named 'datetime-extractor' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'datetime-format'
ModuleNotFoundError: No module named 'datetime-format'  Hi, My... named 'datetime-format' How to remove the ModuleNotFoundError: No module named 'datetime-format' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'datetime-glob'
ModuleNotFoundError: No module named 'datetime-glob'  Hi, My... 'datetime-glob' How to remove the ModuleNotFoundError: No module named 'datetime-glob' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'datetime-interval'
ModuleNotFoundError: No module named 'datetime-interval'  Hi, My... named 'datetime-interval' How to remove the ModuleNotFoundError: No module named 'datetime-interval' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'datetime_periods'
ModuleNotFoundError: No module named 'datetime_periods'  Hi, My... named 'datetime_periods' How to remove the ModuleNotFoundError: No module named 'datetime_periods' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'datetime-quarter'
ModuleNotFoundError: No module named 'datetime-quarter'  Hi, My... named 'datetime-quarter' How to remove the ModuleNotFoundError: No module named 'datetime-quarter' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'datetime_truncate'
ModuleNotFoundError: No module named 'datetime_truncate'  Hi, My... named 'datetime_truncate' How to remove the ModuleNotFoundError: No module named 'datetime_truncate' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'datetime_utils'
ModuleNotFoundError: No module named 'datetime_utils'  Hi, My... named 'datetime_utils' How to remove the ModuleNotFoundError: No module named 'datetime_utils' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'format_datetime'
ModuleNotFoundError: No module named 'format_datetime'  Hi, My... named 'format_datetime' How to remove the ModuleNotFoundError: No module named 'format_datetime' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'helper_datetime'
ModuleNotFoundError: No module named 'helper_datetime'  Hi, My... named 'helper_datetime' How to remove the ModuleNotFoundError: No module named 'helper_datetime' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'hypothesis-datetime'
ModuleNotFoundError: No module named 'hypothesis-datetime'  Hi, My... named 'hypothesis-datetime' How to remove the ModuleNotFoundError: No module named 'hypothesis-datetime' error? Thanks   Hi
ModuleNotFoundError: No module named 'JSON-Datetime'
ModuleNotFoundError: No module named 'JSON-Datetime'  Hi, My... 'JSON-Datetime' How to remove the ModuleNotFoundError: No module named 'JSON-Datetime' error? Thanks   Hi, In your python
database
database  use of hyperlink to show the data from database
database
database  i need to insert time in my database. i need a code to insert time in my database. its very urgent
struts2 datetime picker
struts2 datetime picker  i created a field with sx:datetimepicker with the name fromdate. and i wrote getters and setters for fromdate with datatype string. when im reading data im getting date+time but i want only date can u
datetime picker in struts2
datetime picker in struts2  i used datetimepicker and i created getters and setters with retutn type string when im reading date value which i entered through getter im getter date as well as time i want date only how can i get
database
database  im doing my project in netbeans swings...wn a user wants to create a database from the gui...i want to display an error msg if a database with that name already exists and if it does not exist new database should
database
database  tell me use about database and give me a small program.   It is secure and can easily be accessed, managed, and updated. Moreover... links: Connect JSP with database Mysql Connect Java with database Mysql

Ads