Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2014-03-10
1
Medium Priority
?
603 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 23

Accepted Solution

by:
David earned 1000 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

Understanding Linux Permissions

Linux for beginners: How to view the permissions associated with files and directories and also how you can change them.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

730 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