oracle - SQL "Where" syntax for is today -

-

i need entrys curdate today... curdate of type timestamp. of course searched in google think have used wrong keywords.

select * ftt.element fee, ftt.plan p  p.id=ftt.p_id , curdate ???  order p_id, curdate desc;

could provide me?

sysdate returns current datea and time in oracle. date column contains time part in oracle - timestamp column well.

in order check "today" must remove time part in both values:

select *  ftt.element fee   join ftt.plan p on p.id=ftt.p_id  trunc(curdate) = trunc(sysdate) order p_id, curdate desc;

you should used using explicit joins instead of implicit joins in where clause.

if need take care of different timezones (e.g. because curdate timestamp time zone) might want use current_timestamp (which includes time zone) instead of sysdate


Comments

Post a Comment

Popular posts from this blog

c++ - Creating new partition disk winapi -

-
i'am trying create new partition , mount volume new, thought createfile let me this, code : lpctstr lpfilename=l"\\\\.\\device\\harddisk0\\partition3"; handle handl=createfile( lpfilename, generic_read | generic_write, file_share_read | file_share_write, null, create_always, file_attribute_normal, null ); if (handl==invalid_handle_value) { qdebug()<<"handl invalid"<<" error"<<getlasterror();} bool success = definedosdevice(ddd_raw_target_path,l"i:",l"\\device\\harddisk0\\partition3"); if(!success) qdebug()<<" definedosdevice failed "<<getlasterror(); bflag = getvolumenameforvolumemountpoint( l"i:\\", // input volume mount point or directory /** u in dir...
Read more

VBA function to include CDATA -

-
i have following function include cdata: function cdatasection() dim objdom domdocument dim objkmlrootelement ikmldomelement dim objkmlelement ikmldomelement dim cdata ikmldomcdatasection set objdom = new domdocument set objkmlrootelement = objdom.createelement("balloonstyle") objdom.appendchild objkmlrootelement set objkmlelement = objdom.createelement("text") objkmlrootelement.appendchild objkmlelement set cdata = objdom.createcdatasection("text") cdata.data = "<![cdata[<b>latitude = $[latitude]</b>?]]>;" end function when run above, getting error "user defined data type not found" function. yes ripster says find library reference. vba window tools>references for list of relevant references see... http://msdn.microsoft.com/en-us/library/windows/desktop/ms763701%28v=vs.85%29.aspx however, if have hard time tracking down reference, replace dim sta...
Read more

php - Warning: file_get_contents() expects parameter 1 to be a valid path, array given 16 -

-
i have got problem script, i'm trying connect each url each array, got warnings. warning: file_get_contents() expects parameter 1 valid path, array given: in /home/myusername/public_html/simple_html_dom.php on line 78 here line 78 simple_html_dom.php: $contents = file_get_contents($url, $use_include_path, $context, $offset); here output: warning: file_get_contents() expects parameter 1 valid path, array given in /home/myusername/public_html/simple_html_dom.php on line 78 warning: file_get_contents() expects parameter 1 valid path, array given in /home/ytestbox/public_html/simple_html_dom.php on line 78 warning: file_get_contents() expects parameter 1 valid path, array given in /home/myusername/public_html/simple_html_dom.php on line 78 warning: file_get_contents() expects parameter 1 valid path, array given in /home/myusername/public_html/simple_html_dom.php on line 78 warning: file_get_contents() expects parameter 1 valid path, array given in /home/myusername/publi...
Read more