Oracle SQL comparing dates - 


sql> select * porder ;     oid       bill odate   ------ ---------- ---------     10        200 06-oct-13      4      39878 05-oct-13      5     430000 05-oct-13     11        427 06-oct-13     12        700 06-oct-13     14      11000 06-oct-13     15      35608 06-oct-13     13      14985 06-oct-13      8      33000 06-oct-13      9        600 06-oct-13     16        200 06-oct-13     oid       bill odate ------ ---------- ---------      1        200 04-oct-13      2      35490 04-oct-13      3       1060 04-oct-13      6        595 05-oct-13      7        799 05-oct-13  16 rows selected.     sql> select * porder odate='04-oct-2013';  no rows selected

please help...why isn't query working..??

in oracle, date has time component. client may or may not display time component, still there when try equality comparison. want compare dates dates rather strings use current session's nls_date_format doing implicit conversions making them rather fragile. involve either ansi date literals or explicit to_date calls

you can use trunc function truncate date midnight

select *   porder  trunc(odate) = date '2013-10-04'

or can range comparison (which more efficient if can benefit index on odate)

select *   porder  odate >= to_date( '04-oct-2013', 'dd-mon-yyyy' )    , odate <  to_date( '05-oct-2013', 'dd-mon-yyyy' );

Comments

Post a Comment

Popular posts from this blog

php - Add the correct number of days for each month -

using following function can display years , months between 2 dates, how can add correct days each month array within each month? can't add days manually need account leap years etc. function yearmonth($start_date, $end_date) { $begin = new datetime( $start_date ); $end = new datetime( $end_date); $interval = new dateinterval('p1m'); // 1 month interval $period = new dateperiod($begin, $interval, $end); foreach ( $period $dt ) $years[$dt->format( "y" )][] = $dt->format( "f" ); return $years; } $list = yearmonth("2007-03-24", "2009-06-26"); var_dump($list); since nobody else answered: function yearmonth($start_date, $end_date) { $begin = new datetime( $start_date ); $end = new datetime( $end_date); $interval = new dateinterval('p1d'); // 1 month interval $period = new dateperiod($begin, $interval, $end); $lastmonth = null; $lastyear = null; $aresult = array(); forea...
Read more

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more