?
Solved

Date comparison...database query

Posted on 2002-05-16
6
Medium Priority
?
269 Views
Last Modified: 2012-06-27
I have a form which passes 3 values (day, month, year).

I concat. the 3 values together..

$sdate = sdate_dd + "-" + sdate_mm + "-" + sdate_yy;

how can I do a SQL query to retrieve records less than this date? I am using ORacle database.

my current query is as follows:
==
$query = "select * from tableA where sdate < $sdate";
==

but it complains with the following message
==
OCIStmtExecute: ORA-01861: literal does not match format string
===
0
Comment
Question by:slok
[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
6 Comments
 
LVL 6

Expert Comment

by:andreif
ID: 7013465
maybe you shoud better ask this in Oracle topic?
0
 
LVL 8

Expert Comment

by:us111
ID: 7013604
oracle format is :
YYYY-MM-DD
so try
$sdate = sdate_yy."-".sdate_mm."-".sdate_dd;
0
 
LVL 40

Expert Comment

by:Richard Quadling
ID: 7013626
You should also check to make sure that the century is present in the year.

If you have a form with this in then you could ask for the century as a seperate field (select 19 and 20) and year (select 00 to 99).

Richard.
0
 
LVL 3

Author Comment

by:slok
ID: 7015359
I found the answer.

Apparently, when constructing the query statement in PHP, I need to insert quotes for the date variable and also make use of the to_date function

eg
===
$query = "select * from tableA where sdate < to_date('$sdate', 'dd-mm-yyyy')";
==

Note: take note of the single quotes around $sdate and also the use of to_date function.


Thanks all for the help. I will delete this question in one week's time.
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 11688190
Submitted to PAQ with points refunded (50)

DarthMod
Community Support Moderator
0

Featured Post

Are You Using the Best Web Development Editor?

The worlds of web hosting and web development are constantly evolving. Every year we see design trends change, coding standards adapt and new frameworks/CMS created. With such a quick pace of change it’s easy to get lost trying to keep up.

See if your editor made the list.

Question has a verified solution.

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

This article discusses how to implement server side field validation and display customized error messages to the client.
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to dynamically set the form action using jQuery.
Suggested Courses

771 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