1. Problem in retrieving data with java.util.Date() coderanch.comOn the GUI is the user selecting the time portion as well or just the date? Does the created query look something like this: select insertDt from table where insertDt>=2001-08-17 and insertDt<=2001-08-17; If the GUI just presents the date you may tack on time strings to java.util.Date calls to the query ends up like: select insertDt from table where insertDt between ... | ||||||||||
2. problem retrieving date type from database. coderanch.comI have come across a peculiar problem when I try to deploy ear in Weblogic Sun Solaris. I am trying to fetch data from a table which has a field of type DATE. I am using resultset.getObject(index) method to get the object for each column in the table. The issue starts here. In my windows system when I try to get ... | ||||||||||
3. retrieve date coderanch.comHi! I have an application wherein i insert some records into the database. i also have a field called date which is date YEAR TO YEAR (Informix). So it takes only the year. But now i need the day and month also. Is there any way by which i can retrieve the day and month when these records were inserted. If ... | ||||||||||
4. How to retrieve a date value coderanch.comi am using postesql 8.1. in my table test have one field insertdate its data type is "date". manually i entered a date, 29-11-2005 , i got error AN error has occured. ERROR: date/time field value out of range:"29-11-2005" HINT: perhaps you need a different "datestyle"setting. when i entered this way date 2005-11-29 its stored in the table. but actually i ... | ||||||||||
5. retrieving date field from access database using query coderanch.comHi all, Am unable to retrieve the users information according to the datewise through the query from access database. The datefield datatype is declared as 'shortdate'. The error is showing as "datetype mismatch criteria". eg: select name,ddate,department from tablename where ddate between '2006-12-01' and '2006-12-31'; I tried in all date formats like mm/dd/yyyy,dd/mm/yyyy and so on. Thanks in advance, Siva | ||||||||||
6. retrieving date field from access database using query coderanch.comHi all, Am unable to retrieve the users information according to the datewise through the query from access database. The datefield datatype is declared as 'shortdate'. The error is showing as "datetype mismatch criteria". eg: select name,ddate,department from tablename where ddate between '2006-12-01' and '2006-12-31'; I tried in all date formats like mm/dd/yyyy,dd/mm/yyyy and so on. Thanks in advance, Siva | ||||||||||
7. SQL to retrieve date vals from ORA-DB coderanch.comHello Friends, I am trying to retrieve info from the Oracle DB, with a SQL statement which looks something like: Select * from tblORA where tblDate = ('myDate','MMDDYYYY') Can myDate be of type String? I am trying to retrieve a date of String type from another page and insert that date into the SQL statement. What would be a good way ... | ||||||||||
8. How to retrieve Date from JDBC using sql coderanch.comI can get the date from database using this this coding Date dat=rs.getDate(4); but i cannot set this date to calender when user wants to view means. in textfield we can set the text using this method -> jTextField1.setText(rs.getString(1)); but in calendar how to set selected date to set ? like calcombo.set???(dat) i want to set calendar like above jTextField1. which ... | ||||||||||
9. How can I retrieve date using rs.getDate() ? coderanch.comHi, here's my code .. InitialContext ctx = new InitialContext(); DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/MyDataSource"); con = ds.getConnection(); String query = "SELECT * FROM CMPJOBADD WHERE JOBID=?"; ps = con.prepareStatement(query); ps.setString(1,request.getParameter("jobid").toString()); rs = ps.executeQuery(); out.println("
|