1. Prepared statement help coderanch.comHello everyone, I am having some trouble with prepared statements. I am getting an error when I try to run this code: <%@ page import="java.sql.*,oracle.jdbc.driver.*, oracle.sql.*,java.io.*,javax.sql.*,java.awt.*,java.util.*,javax.servlet.*" %> <% Class.forName("oracle.jdbc.driver.OracleDriver()"); Connection connection = DriverManager.getConnection("jdbc :-o racle:thin:@100.100.100.1:1521:epics","workorder","workorder"); String vtxt1 = request.getParameter("txt1"); String vtxt2 = request.getParameter("txt2"); PreparedStatement pstmt = connection.prepareStatement("insert into bobtest(txt1,txt2) values (?,?)", ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); pstmt.setString(vtxt1,vtxt2); pstmt.executeUpdate(); %>Record Inserted...<% ... |
2. jdbc prepared statement coderanch.com |
3. Prepared statement coderanch.comok lets assume if this code below works fine for you. String query = "SELECT * FROM |
4. Prepared statement, Execution plan and Indexes coderanch.comWe have a web application that uses JSP and Java to connect to a SQL Server database. Inside the application there is a module that does a batch import of data into the database. The data import reads data from a flat text file, and uses PreparedStatement to validate the data and insert records into the database. For reasons unknown to ... |
5. Prepared Statement coderanch.com |
6. Prepared Statement coderanch.com |
7. Prepared Statement coderanch.com |
8. preparedstatements coderanch.com |
9. PreparedStatement coderanch.com |
10. PreparedStatement - to use or not to use coderanch.comHi, I have few DAO methods for data fetch - each method has just one query which will be executed only once (it doesn't have multiple inputs for which that query needs be excuted with different sets of inputs during one call to this method). Then next time, that DAO Method gets called, it recreates the SQL query with new set ... |
11. Help with FK in PreparedStatement coderanch.comHey JDBC gurus! Need help. Im working with PreparedStatement to commit a transaction with info to two database tables. The problem is that the second tables INSERT statement needs to know which primary key the first tables INSERT was given, so that the second tables foreign key can be set to the correct value. The foreign key in the second table ... |
12. Prepared Statement with wild card coderanch.com |
13. PreparedStatement executeUpdate() coderanch.com |
14. Prepared Statement coderanch.com |
15. question regarding PreparedStatement coderanch.comHi all, I wonder what is the difference between the following 2 codes: public void method1(String[] cityList) throws Exception { for (int x=0; x |
17. Difference in PreparedStatement and OraclePreparedStatement coderanch.com |
18. need a sample code JDBC ..preparedstatement coderanch.com |
19. Help on PreparedStatement coderanch.comMondli, JavaRanch is a community of people from all over the world, many of who are not native English speakers. While using abbreviations like "u" instead of spelling out "you" is convenient when text messaging your friends on a cell phone or in a chat room, it presents an extra challenge to those that are already struggling with English. Additionally, such ... |
20. How Does PreparedStatement Work internally coderanch.comHi Java Pals, Can any explain exactly, how PreparedStatemet Works? Any how excatly it makes difference in preformace compared to its base class Statement Class? I request people to explain the internal aspects of working, I found only its syntax and usage on sites but no where i found its internal working. It will be helpful to all, if you give ... |
21. PreparedStatement not working coderanch.com |
22. Strange JDBC PreparedStatements Problem coderanch.comI also tried setInt(1, 1), it did not work. It turns out that there is a bug with MySQL and server side PreparedStatements. There are several bug reports in the MySQL bug database, and some of them have been confirmed (and fixed in more recent versions). I filed a bug in the Ubuntu Bugzilla, and hope they will upgrade their distribution ... |
23. Prepared Statement Hanging. coderanch.com |
24. create a JavaBean having prepared statement coderanch.com |
25. is that a bug with PreparedStatement ? coderanch.comIt is a good design practice to avoid NULLs when possible. If you are using Oracle you can use the Oracle specific function NVL So nvl(name,'Null Name') = nvl(?,'Null Name') will return TRUE. Obviously this means you need a functional index on nvl(name) to optimize access. Of course this means your application won't work with other databases. There are other ways ... |
26. Help with PreparedStatement coderanch.comElihu, I agree with Michael. You need to have one table with a column for client id. Then you can do queries like: select columns from clientinfo where clientId = ? This is still a simple query. And this gives you a good opportunity to learn more about SQL! If you have questions about SQL, feel free to post them here. ... |
27. PreparedStatement slows down coderanch.comHello, I try to insert many rows (up to 5000) with ca. 40 Columns into MS Access over the driver sun.jdbc.odbc.JdbcOdbcDriver. Autocommit is false. So to have a better performace I tried to use a PreparedStatement: PreparedStatement prepUpdate = m_dbAccess.getConnection().prepareStatement("INSERT INTO tb_Clients_History VALUES(?,?...)"); while(...) { prepUpdate.setString(1,"data0"); .... prepUpdate.setString(40,"data40")); prepUpdate.executeUpdate(); } prepUpdate.close(); m_dbAccess.getConnection().commit(); This solution is very slow. So I tried to ... |
28. Prepared statement - when to use and when not to coderanch.comHello , Couple of questions related to prepared statement that am confused ( w.r.t Oracle ) 1 > Execute a PreparedStatement 2 > Believe Oracle parses / creates execution plan and stores this in "Library Cache" ? 3 > Question : If I close the Prepared statement and close the connection - would this affect the query plan in the "Library ... |
29. PreparedStatement - NOT IN (?) is mis-behaving coderanch.comIn the following piece of code String sql = select col1,col2,col_STATUS, col_TIMESTAMP from MyTable where col_STATUS not in (?) and col_TIMESTAMP+? < SYSDATE"; pstmt = connection.prepareStatement(sql); pstmt.setString(1,"' ','XX'"); pstmt.setInt(1,4); The results are ignoring the the first clause and bringing the results. Instead When I replaced the first ? with ' ','XX', and second ? with 1 and used stmt = connection.createStatement(). ... |
30. prepared statement issue coderanch.comYes. I used the M$ sql profiler and took the trace. it shows 40secs for the query executed through java pgm and 3 secs through query analyser. and there is not much n/w traffic to my amazement. i tried that with a linux tool. will there be any prob in the case of too much arguements (43 in total) and it ... |
31. Reuse PreparedStatement coderanch.comHi I am reading JDBC 3 Specs and found the enhancement "Reuse of prepared statements by connection pools" it is not clear to me and when I search it on google it create more confusion to me. First thing what is in my mind is when we use preparedStatement as /*************************************************/ 1 - PreparedStatement ps = conn.prepareStatement(SQL); 2 - ps.setInt(1 , ... |
32. Printing PreparedStatements to log file coderanch.comI read the information in the FAQ about using Debuggable to accomplish this. The article at JavaWorld said that the Debuggable package was a Java package. I don't see it in JavaDocs and I didn't see it available for download at Sun. I must be missing it somewhere. Where do I get the Debuggable package? |
33. Doubt about PreparedStatement coderanch.com |
34. Having problem with prepared statement coderanch.comThis is what i'm trying to acheive. Each result which appears in the table will have a delte link. When i click on it i need it to delete that particular record from the database. I get the following error. What might be wrong. Thank you for your help. javax.servlet.ServletException: You have an error in your SQL syntax; check the manual ... |
35. Why PreparedStatement is so called precompiled? coderanch.com |
36. Cursors and PreparedStatements coderanch.comHi guys, i used the built-in google search to check if any previous posts might be relevant and found none so i am posting this question. Our DBA is having troubles with having too many cursors with a specific sql. i am not authorized to post the exact sql. but here is a general idea. initially, the table has 25+ fields ... |
37. UPPERing in a prepared statement coderanch.com |
38. UPPERing in a prepared statement coderanch.com |
39. PreparedStatements coderanch.com |
40. precompilation of PreparedStatements coderanch.comThis depends on the database. Oracle for instance will cache parsed SQL and execution plans in its own shared memory area. They will stay there even if the session that first submitted it drops the connection, unless and until they are aged out by more recently requested statements needing the space. [ December 12, 2006: Message edited by: Chris Hendy ] ... |
41. Informix Prepared Statement coderanch.comI'm having the following problem: - I have a PreparedStatement that works fine with the following SQL (it retrieves a date and converts it to char): sql = "SELECT TO_CHAR(TO_DATE(M.call_date || ' ' || M.seize_time), ?) part_actual_start, M.CROSS_REF part_id FROM DATES_TABLE M" stmt = con.prepareStatement(sql); stmt.setString(1, ifxTimeFormat); - Whenever I attempt to append more text an exception is thrown (I append ... |
42. preparedstatement coderanch.comI have this code for example.......... sqlstmt = "UPDATE CATEGORIES SET SUB=? , HAS_SUB=? WHERE ID=?"; pstmt = conn.prepareStatement(sqlstmt); pstmt.setString(1,subcatids); pstmt.setString(2,"Y"); pstmt.setString(3,selsubcat); pstmt.executeUpdate(); There is no problem in code...and query updated successfully... but here i want to print the 'sqlstmt' statement....to know what exactly query contain in place of palce holder (?)... how can print it with preparedstatement.... Reply me ASAP ... |
43. proble with preparedStatement coderanch.comHi All, I am facing a problem with preparedStatement.executeUpdate(). My requirement is that I will execute an update query first and I need to log the result of executing query. My expectation is that, when no records are updated zero will be returned. But all the times it returns the number of rows matched. I tried even getUpdateCount(). Solution should work ... |
44. Printing prepared statement to console coderanch.com |
45. Using a prepared statement coderanch.comHi, I have a class with a method takes in a connection object and a string called criteria that contains search parameters. I used to have the method findInstructors() working using a simple select statement, but this leaves it vulnerable to SQL and Javascript injection. So I want to use a prepared statement, but I'm have a little trouble. Here is ... |
46. prepared statement coderanch.com |
47. prepared statement coderanch.com |
48. drop database with PreparedStatement coderanch.com |
49. regarding preparedstatement coderanch.com |
50. regarding preparedstatement coderanch.com |
51. Cannot convert from Prepared Statement to Prepared Statement coderanch.com |
52. Prepared Statement coderanch.comUser. It reads the ?'s in order they are in the SQL query string. The database does not rearrange them. Actually a better way to say it is that the database doesn't even see the prepared statement, it just sees the finalized SQL string with the values filled in. [ October 04, 2007: Message edited by: Scott Selikoff ] |
53. Problem in PreparedStatement coderanch.com |
54. Prepared statement coderanch.com |
55. PreparedStatement! coderanch.comChandra, When the driver/database/connection sees a SQL statement, it figures out how to execute it. If the string matches exactly one executed recently, it re-uses the plan. This is related to pre-compiling. In your first example, the SQL is exactly the same since a question mark is used. In your second example, the query is different and the database treats it ... |
56. prepared statement coderanch.comHave read that Prepared statement is more efficient than using plain Statement . Question 1 > Why is it so ? Think it is related to the statement being precompiled So Is it correct to infer that Prepared statement is precompiled while a simple statement is not ? Question 2 > If Prepared statement is indeed precompiled - than where is ... |
57. Prepared Statement coderanch.comI have more than a table with empid as primary key and it is auto increment. i have two more tables. those also have empid so i made them as foreign key as these table are dependent . my problem is when i try to submit my page fields belong to different tables but for that particular emp id only i ... |
58. Regarding PreparedStatement coderanch.comHi, I know that to get the row count from sql we should give as follows select count(*) from tablename where columnName = value; is this wright Now my problem is, actually i am adding students data in the table from text fields. But what i need is the maximum row count for each roll number should be 3. There should ... |
59. prepared statement with "in" predicate coderanch.com |
60. PreparedStatements and precompiled? coderanch.comThey have different meanings, in fact one is used within the other (for PreparedStatements). Precompiling is a step that involves preparing the SQL statement for execution on the Database server, you often want to do this if the SQL is going to be executed more than once. Binding forms part (but not all) of that precompilation step. |
61. Prepared Statement coderanch.comHow does the databases identify the request is for prepared statement? What is the process flow of handling prepared statement (starting from webserver to database server and back to webserver)? I read from an article that prepared statements are using precompiled statement and after syntax check, compilation and optimization, handle is returned to the JDBC driver. At the end of the ... |
62. problem with prepared statement coderanch.comWhy have you got single quotes around APP and BOOKS ? What happens if you remove them? What I am thinking is that the single quote is used in SQL to contain strings, and I believe jdbc implicitly puts one at the start and end of a prepared statement. So when one is encountered embedded in the middle of your sql ... |
63. Synchronization issue with PreparedStatement coderanch.comDear All I am facing a strange issue. We have to delete some roles from our application .As per business logic before deletion of roles we store them into ou archive table and once they are stored then we delete them from our main table This logic works fine with single user environment but whenever testing is performed on multi user ... |
64. Webspehere Prepared statement coderanch.comjava.lang.ArrayIndexOut OfBoundsException: Array index out of range: 0 [12/4/08 11:18:35:523 IST] 00000023 SystemErr R at oracle.jdbc.dbaccess.DBDataSetImpl._getDBItem(DBDataSetImpl.java:378) [12/4/08 11:18:35:523 IST] 00000023 SystemErr R at oracle.jdbc.dbaccess.DBDataSetImpl._createOrGetDBItem(DBDataSetImpl.java:781) [12/4/08 11:18:35:523 IST] 00000023 SystemErr R at oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2450) [12/4/08 11:18:35:523 IST] 00000023 SystemErr R at oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1155) [12/4/08 11:18:35:523 IST] 00000023 SystemErr R at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:1572) [12/4/08 11:18:35:523 IST] 00000023 SystemErr R at com.ibm.ws.rsadapter.spi.InternalOracleDataStoreHelper.psSetString(InternalOracleDataStoreHelper.java:333) [12/4/08 11:18:35:523 IST] 00000023 SystemErr ... |
65. What is the result of Prepared Statement coderanch.com |
66. When not to use PreparedStatement coderanch.com |
67. PreparedStatements coderanch.comHis question was rather regarding committing and rollbacking. Well, that's fairly obvious. If you have multiple queries on a single connection which depends on each other (a transaction), then you may need to rollback the complete transaction when executing a query fails. This is only useful if autocommit is set to false. This is fairly important if you're using connection pooling, ... |
68. prepared statement in for loop coderanch.comHi all, I am inserting data into a table. For this i am using prepared statement in a for loop. I am able to insert the 1st row into the database, but while inserting 2nd row it is throwing a sql "General Error" exception. try { //AddPOForm objAddPOForm = (AddPOForm)form; //System.out.println("CUST NAME::"+objAddPOForm.getSelected()); strCustName = (String)poForm.get("selected"); System.out.println("CUST NAME:"+strCustName); AddPOBean[] lines = (AddPOBean[]) ... |
69. Converting to prepared statement coderanch.comI am trying to convert a simple sql to prepared stmt..I am expecting the following functions to behave same..but I guess they dont. Can someone guide me with the correct implementation please.. private String getUPSql(ClassInvetoryItem id) { StringBuffer pSql = new StringBuffer(); pSql.append("SELECT * from inventory_table it WHERE it.itemId = id.getItemId()"); return pSql.toString(); } private String getUPSql(ClassInvetoryItem id) { Connection connection ... |
70. Help needed: using setQueryTimeout() on prepared statement coderanch.com |
71. How to pass a List in PreparedStatement.setArray()? coderanch.com |
72. Problem creating a PreparedStatement coderanch.com |
73. PreparedStatement in batched mode gives Exception coderanch.comHi I have a problem. I am running PreparedStatement in batched mode, actually I am using Springs BatchSQLUpdate component. Now i am creating a batch of about 10000 inserts / updates. However if any single of these inserts / updates fails, it gives exception with DataIntegrityViolation, BadSQLGrammer etc. I am also maintaining a parallel cache of the values that I am ... |
74. prepared statement in jdbc coderanch.comiam getting two errors in this code one is at prepared sttement object and the other at pst.executeUpdate() these two errors are coming at lines 52 & 72 of the below code here in this code whenever the result of ping is "request timed out " iam storing the date of that in the database and that iam doing with prepared ... |
75. setBlob() method fro preparedstatement coderanch.comHi, I am trying to insert a video into oracle database using setBlob() mwthod of the PreparedStatement interface. My code is compiling sucesfully but i am getting a runtime error. My code is: import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import javax.sql.rowset.serial.*; public class Blob { public static void main(String[] args) throws Exception, IOException, ... |
76. can we write this method using prepared statement? coderanch.comi found that to avoid sql injection use prepared statement.But is it possible to use prepared statement for all times. public boolean checklogin(String username,String password){ boolean login=false; try { Statement statement=connection.createStatement(); ResultSet result=statement.executeQuery("SELECT * FROM student WHERE username=" + "'" + username + "'"); //ResultSet rs2 = statement.executeQuery("SELECT * FROM voter_details WHERE NID=" + "'" + nic + "'"); while(result.next()){ String ... |
77. PreparedStatement coderanch.comPrecompiled :- Below are the steps involved to execute normal query using Java. 1.Java code will transfer the query to database 2. Database will compile the query. 3. Database will execute the query. For prepared statement, first time all three steps will take part but from 2nd time onwards, step 1 and 3 only takes part in execution. Step -2 will ... |
78. PreparedStatement, setBinaryStream, and outOfMemoryError coderanch.comI'm trying to load very file files into a mysql db, and I'm frustrated. I set up a prepared statement, used setBinaryStream to input the file, and executed only to have the outOfMemoryError bite me. My understanding given the javadoc is that using the setBinaryStream method will allow me to basically stream the file in rather than holding the entire thing ... |
79. PreparedStatements coderanch.com |
80. Prepared statement's 'setDate' method coderanch.comHi Pushkar Ops....sorry to have spelled your name wrongly earlier. In my haste I have posted my question in the JSP forum. I agree that JDBC would have been the more appropriate forum. I dont think I can move the to the JDBC forum myself, I hope moderators will be kind enough to do it. Thanks and sorry for the trouble. ... |
81. Using PreparedStatement coderanch.comcom.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'com.mysql.jdbc.PreparedStatement@11f2ee1: insert into customer(id) values(1)' at line 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485) at com.jdbcdemo.JdbcDemo.main(JdbcDemo.java:30) |
82. Prepared Statement trouble coderanch.comI apologize in advance if I did not post this in the correct forum. I'm having trouble getting my prepared statement to execute properly. I have tried creating the SELECT query many different ways this is just one of them. When this method is called it prints out string from System.out.println("BEfore DB call. " + pg + " " + perPg); ... |
83. JDBC Prepared Statement BatchStatement within a while loop coderanch.com |
84. Using Like in preparedstatement coderanch.com |
85. Prepared Statement coderanch.com |
86. JDBC Prepared Statement - multiple datatypes as input coderanch.comHi Please see the code and let me know if you find anything wrong. I have explained the details after the code: public static void main(String[] args) { String clsName = "oracle.jdbc.driver.OracleDriver"; String url = "jdbc:oracle:thin:@host:1521:SID"; ResultSet rs = null; Connection con = null; try { Class.forName(clsName); con = DriverManager.getConnection(url,"user","password"); String query="Select t$emno from baandb.ttccom912900 where t$dpty=? and t$dtyp=?";//t$dpty: STRING t$dtyp: ... |
87. PreparedStatement coderanch.com |
88. preparedStatement coderanch.comI have table Customer (id, name), Address(id, st_add, city, state), Order(randomKey, id, name, st_add, city, state..) The logic is -- 1. I want to do something like SELECT c.id, c.name, a.st_add, a.city, a.state FROM Customer c, Address a INTO Order WHERE c.id = a.id But that's not exactly. I also need to create a run time randm number (by java code) ... |
89. Jdbc Prepared Statement execute() coderanch.comHi I have written the following code. After execution when I give inpt from command line it does not do anything. Please tell me is there anything wrong in code. package com.nitish.jdbc.preparedstatement; import java.sql.*; import java.io.*; public class Jdbc13{ public static void main(String []s)throws Exception{ System.setProperty("jdbc.drivers","oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","nitish"); String query = " "; PreparedStatement ps = con.prepareStatement(query); BufferedReader br ... |
90. JDBC preparedStatement vs Stored Proc ? coderanch.com |
91. DB issue (prepared statement) coderanch.comHi All, I am using TYPE_SCROLL_SENSITIVE and CONCUR_READ_ONLY to iterate through the result set object in both directions. statement = connection.prepareStatement(query, rs.TYPE_SCROLL_SENSITIVE,rs.CONCUR_READ_ONLY); Query: SELECT DISTINCT POL_NO, P_CODE, P_LN, MAX(EFF_DT) AS EFF_DT, T_TYP, PER_FROM, PER_TO, BUS_TYP FROM DMGT.ARC WHERE BUS_TYP IN ('C', 'P') AND POL_NO = ? AND (ERR_IND ! = 'X' OR ERR_IND IS NULL) GROUP BY T_TYP, PER_FROM, PER_TO, POL_NO, ... |
92. PreparedStatement not valid coderanch.com |
93. PreparedStatement fails to execute coderanch.com |
94. Problem while using prepared statement coderanch.comI have created the following program using prepared statement, but I am not able to go through and fetch its output accordingly.Please help.This is the program import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.sql.*; public class log extends JFrame implements ActionListener { String s1,s2; JLabel l1=new JLabel("UID"); JLabel l2=new JLabel("PWD"); JButton b3=new JButton("RESET"); JLabel l3=new JLabel(); JTextField t1=new JTextField(10); JPasswordField t2=new ... |
95. PreparedStatement doubt coderanch.comyes, it gets done by the database the first time the SQL is executed. The database maintains a pool of these precompiled execution plans and decides when (or if) to forget some to free the memory. To be honest I doubt you'd notice the difference between a statement that runs from a precompiled execution plan and one that compiles the statement ... |
96. PreparedStatement (displaying records) coderanch.comYour declare i as a variable at the start of your program. Why? You will only concatenate a String if you have two results returned. So you should print the contents of a.aa from the first row concatenated with cc from the second row. If you have any more than two results you will get an exception. I would revisit your ... |
97. Can we use two quries using prepared statement in one method coderanch.comHI all! Can we use two quries in one method while using prepared statement, i have tried using this but invalid column name exception is comeing. Any idea please? My code snippets is as follows. public double getPayroll(){ ResultSet rs = null; ResultSet rs2 = null; Connection conn = null; PreparedStatement pstmt = null; try { conn = getDBConnection(); int employeeId; ... |
98. PreparedStatement Change coderanch.comI am trying to convert this dyanamic query into a preparedStatement to fetch data from a table in an efficent way.The query has 4 attributes which are required to be displayed according to the user input and even if the user enters only one input it should return all the other attributes. query = "SELECT PC.PROD_CAT_ID,PC.HERITAGE_CD,PC.PROD_SHRT_DESC,PC.PROD_LONG_DESC,SOR.MNEMONIC,SOR.LOCATION_CD," + "PC.PROD_DSPLY_DESC,PC.AFF_ELIGIBLE,PC.INTEREST_BEARING FROM " + ... |
99. Internal implementation of Prepared Statement coderanch.com |
100. PreparedStatement.setDate() is cutting the time part coderanch.comWhen you say "queries" I assume you're talking about Java code which gets data from the database. In which case it's completely up to you how you display the dates. You can display them with or without milliseconds. That has nothing to do with how you store the data in the database. |