Question about Oracle 10g Database Standard (ODBSEONUPP0)
I have an Oracle date problem I want to use in the where also a time filter not just a date filter, how do I add it?
where DTTM > '10-Jun-08';
All dates are actually date-time fields - if you don't specify the time, Oracle defaults to midnight. To filter date-time specify the date-time string as a formatted field like this:
select count(*) from mytable where dttm > to_date('20080610181907','YYYYMMDDHH24MISS');
This is the date June 10, 2008 at 6:19:07 PM as an example.
Posted on Nov 28, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Nov 10, 2009 | Computers & Internet
Aug 02, 2009 | Microsoft Office Excel 2007
Jun 08, 2009 | Oracle Database Enterprise Named User Plus
Apr 28, 2009 | Microsoft Computers & Internet
Feb 12, 2009 | Microsoft Computers & Internet
Dec 11, 2008 | Microsoft Computers & Internet
Oct 22, 2008 | Microsoft Access 2002 for PC
Sep 09, 2008 | Oracle 10g Database Standard (ODBSEONUPP0)
Feb 11, 2008 | Microsoft Office Access 2003 (077-02871)...
757 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: