mbasilica

Wednesday, August 13, 2008

Querying a date column in database

To query a date column, use

select * from person_table where date_of_birth >= to_date('01/01/2000', 'dd/MM/yyyy')
Posted by Marie Arul Basilica at 4:46 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Database
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2017 (4)
    • ►  July (1)
    • ►  June (1)
    • ►  April (1)
    • ►  February (1)
  • ►  2016 (9)
    • ►  December (1)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
    • ►  June (1)
    • ►  April (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2015 (9)
    • ►  December (3)
    • ►  October (1)
    • ►  August (1)
    • ►  June (2)
    • ►  April (2)
  • ►  2014 (2)
    • ►  December (1)
    • ►  November (1)
  • ►  2010 (9)
    • ►  July (9)
  • ►  2009 (5)
    • ►  March (1)
    • ►  February (3)
    • ►  January (1)
  • ▼  2008 (51)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  September (1)
    • ▼  August (1)
      • Querying a date column in database
    • ►  July (1)
    • ►  June (33)
    • ►  May (3)
    • ►  April (2)
    • ►  March (4)
    • ►  February (2)
    • ►  January (1)
  • ►  2007 (3)
    • ►  December (1)
    • ►  November (2)

Labels

  • AJAX
  • Database
  • Food
  • Google Map
  • Hibernate
  • HTML
  • Java
  • Javascript
  • JAXB
  • JSON
  • JSP
  • Kid stuff
  • Patterns
  • Quotations
  • Recipe
  • Spring
  • Struts
  • Tomcat
  • Tools
  • Unix
  • Version Control
  • Windows
  • XML Schema
  • XSD

About Me

My photo
View my complete profile
Picture Window theme. Theme images by merrymoonmary. Powered by Blogger.