PL/SQL Working with Date Value


select * from table_name where id=181
and column_date=to_date('28.02.2013 10:39:15', 'dd.mm.yyyy hh24:mi:ss');

select to_char(current_date, 'DD-MM-YYYY HH:MI:SS') from dual;


Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Getting Umbraco Content - IPublishedContent vs IContent vs Node vs Document