|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
February 25th, 2002, 10:55 AM
|
|||
|
|||
|
Dates and Oracle...
Hi,
First a general request to any and everyone... One problem that I hv encountered repeatedly is when dealing with dates in Oracle... Can anyone write a decent article w.r.t handling dates with Oracle such as inserting/updating etcc.. thru an JSP??? ok, coming to my problem... I am trying to compare dates between my form fields and my db field but so far keep getting a format error.. Am using an Oracle Db... my query reads like this: SQL = "SELECT DISTINCT to_char(DOCUMENT.doc_date,'dd/mm/yyyy') doc_date,DOCUMENT.document_code from Document where"; SQL += " doc_date BETWEEN '15/11/1958' AND '15/08/1988 '"; can anyone pl tell me whats wrong up here?? TIA, sands
|
|
#2
February 25th, 2002, 11:06 AM
|
||||
|
||||
|
Google. Google, Google .... http://www.arsdigita.com/books/sql/dates.html
Hope this helps!
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Programming Languages > Java Help > Dates and Oracle... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
