|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
February 23rd, 2005, 04:57 PM
|
|||
|
|||
|
date compare
Hi, I am trying to compare a date field from table with the string passed from user. I am using the below query, there is some error, i could not figure it out.. .any help is greatly appreciated.
select date_field from table where (select date('02/01/2005') from sysibm.sysdummy1) <=date_field and date_field <=(select date('02/28/2005') from sysibm.sysdummy1) Thanks
|
|
#2
February 24th, 2005, 11:54 AM
|
||||
|
||||
|
Why not do something like the following:
select date_field from table where date_field between date('02/01/2005') and date('02/28/2005')
|
|
| Viewing: Dev Shed Forums > Databases > DB2 Development > date compare |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
