Solved

syntax for checking date GT 12/1/2013 in ORACLE - SQL

Posted on 2014-03-10
1
578 Views
Last Modified: 2014-03-11
Experts,

Can someone give me the syntax to check a date time field  for GE 12/1/2013 defined in Oracle as Num8  Datetime20. Oracle  in SQL?
0
Comment
Question by:morinia
1 Comment
 
LVL 23

Accepted Solution

by:
David earned 250 total points
ID: 39918989
Morinia, the question doesn't make sense: "Num....Oracle".  But my first stab is, "...WHERE colx >= TO_DATE('12/1/2013','MM/DD/YYYY');

Assuming colx to be a non-DATE datatype.  Is '12/1/2013' supposed to be numeric, char, or date?   And to Oracle, DATE records the day and time in a binary format.  TIMESTAMP gets into more precision, and allows time zones.

I'll be around if you wish to try again.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now