I agree dates, databases and locales can be horrible, I tend to convert dates into strings of known format then explicitly cast them from Strings into datetimes using SQL. I then always know exactly what I'm doing all the time.
Chris -----Original Message----- From: Adrian Janssen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 10:39 AM To: [EMAIL PROTECTED] Subject: Re: sql Date Hi, That' pretty dangerous, what if the DB is expecting day then month (UK standard) instead of month then day (US Standard) ? From my experience that is a common issue with dates and DB's. It may be poossible to use SQL functions to build the date up. Cheers Adrian > -----Original Message----- > From: G.Nagarajan [SMTP:[EMAIL PROTECTED]] > Sent: 07 May 2002 11:29 > To: [EMAIL PROTECTED] > Subject: Re: sql Date > > hi, > > for inserting a date into the database, i use the following code. > > Calendar cal; // The date to be inserted > String colValue = ""; > colValue = > "'"+(cal.get(Calendar.MONTH)+1)+"/"+cal.get(Calendar.DAY_OF_MONTH)+"/"+cal > .g > et(Calendar.YEAR) > +" "+cal.get(Calendar.HOUR_OF_DAY) + > ":"+cal.get(Calendar.MINUTE)+"'"; > > then.. > > String sql = "Insert into table(...) values ('aa'," + colValue + ")" > > then use sql for inserting the record. > > > hth, > Nagarajan. > > > -----Original Message----- > > From: A mailing list about Java Server Pages specification and reference > > [mailto:[EMAIL PROTECTED]]On Behalf Of Bhushan_Bhangale > > Sent: Tuesday, May 07, 2002 11:14 AM > > To: [EMAIL PROTECTED] > > Subject: Re: sql Date > > > > > > You cannot cast a java.util.Date to a java.sql.Date since the util.Date > is > > the parent class of sql Date. > > > > -----Original Message----- > > From: Emmanuel Eze [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 07, 2002 1:46 PM > > To: [EMAIL PROTECTED] > > Subject: Re: sql Date > > > > > > Even if I do that, how do I then convert the java.util.Date to > > java.sql.Date? > > > > > > -----Original Message----- > > From: Bhushan_Bhangale [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 07, 2002 11:05 AM > > To: [EMAIL PROTECTED] > > Subject: Re: sql Date > > > > > > First of all:- > > > > java.util.sql birthday = null; should be java.util.Date > > birthday = null; > > > > as the Calendar.getTime() method returns a util date object. > > > > -----Original Message----- > > From: Emmanuel Eze [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 07, 2002 1:34 PM > > To: [EMAIL PROTECTED] > > Subject: sql Date > > > > > > Hi all, > > > > Can somebody pls tell me how I can insert a Date type into a > > database table > > with a Date datatype? > > > > I have the year, month, and day as integer values. I need to > > convert these > > values into an sql Date object so I can now insert the Date > > object into the > > table, right? > > > > I have the following code: > > Calendar cbirthday = null; > > java.util.sql birthday = null; > > . > > . > > . > > cbirthday = Calendar.getInstance(); > > cbirthday.set(Integer.parseInt(year), Integer.parseInt(month), > > Integer.parseInt(day)); > > birthday = cbirthday.getTime(); > > > > This last statement throws a cast exception! Even when I change it to: > > birthday = (java.sql.Date) cbirthday.getTime(); > > > > Pls tell me what I'm doing wrongly. > > > > Emma > > > > ================================================================== > > ========= > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > ================================================================== > > ========To > > unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > ================================================================== > > ========= > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set > > JSP-INTEREST DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set > > JSP-INTEREST DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > ========================================================================== > = > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com -- ********************************************************************** The Truworths e-mail facility may not be used for the distribution of chain letters or offensive email. Truworths hereby distances itself from and accepts no liability for the unauthorised use of its e-mail facility or the sending of e-mail communications for other than strictly business purposes. Truworths furthermore disclaims liability for any unauthorised instruction for which permission was not granted. =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This foot-note also confirms that this email message has been swept for the presence of computer viruses. ********************************************************************** =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
