Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 610
  • Last Modified:

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

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
morinia
Asked:
morinia
1 Solution
 
DavidSenior Oracle Database AdministratorCommented:
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now