 |  |  |  |  |  |  |  |
Sql Query Help
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Dec 2004
Posts: 234
Reputation: 
Solved Threads: 0
Posting Whiz in Training
Hello,
I am developing a simple calender in my site which will display the next upcoming birthday of my member.
I have a table which has 2 column
cname | dob
-------------------
Joe | 9/12/1982
Mathew | 2/17/1997
Pat | 8/23/1880
-------------------
What SQL Query should I use to get the name of that person?
I am developing a simple calender in my site which will display the next upcoming birthday of my member.
I have a table which has 2 column
cname | dob
-------------------
Joe | 9/12/1982
Mathew | 2/17/1997
Pat | 8/23/1880
-------------------
What SQL Query should I use to get the name of that person?
Hi, i think the following should help / give you an idea (eg retrieves names of members whose dob falls in current month--according to system date)
select cname from tablename wherE
datepart (mm,convert(datetime,dob))
= (select datepart(mm,convert(datetime,getdate())) )
select cname from tablename wherE
datepart (mm,convert(datetime,dob))
= (select datepart(mm,convert(datetime,getdate())) )
•
•
Join Date: Dec 2004
Posts: 234
Reputation:
Solved Threads: 0
Posting Whiz in Training
Thanx but it generates this error
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error. in query expression 'datepart (mm,convert(datetime,dob)) = (select datepart(mm,convert(datetime,getdate())))'
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error. in query expression 'datepart (mm,convert(datetime,dob)) = (select datepart(mm,convert(datetime,getdate())))'
Last edited by cancer10; Nov 7th, 2006 at 11:23 am.
•
•
Join Date: Dec 2004
Posts: 234
Reputation:
Solved Threads: 0
Posting Whiz in Training
Yes I am using Access and Jet
Any other solution?
Any other solution?
•
•
•
•
Originally Posted by cancer10 
Yes I am using Access and Jet
Any other solution?
Dont forget to spread the reputation to those that deserve!
|
Similar Threads
- sql query problem with MS Access and C# (C#)
- Urgent Help with SQL Query (MySQL)
- C# VS 2005 - SQL Query Parameters to an ODBC DataSource (C#)
- sql query updating problem (Visual Basic 4 / 5 / 6)
- Javascript array from sql query (JSP)
- Please help me out with MySQL query (MySQL)
- PHP/SQL query help (PHP)
- Retreiving variables from a sql query into a form (PHP)
Other Threads in the MySQL Forum
- Previous Thread: PHP Form, SQL connectivity issues, please help.
- Next Thread: Change MySQL Query Timeout Period
Views: 3730 | Replies: 5
| Thread Tools | Search this Thread |
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MySQL
"use" 1 agplv3 alfresco amazon api artisticlicense breathalyzer camparingtocolumns changingprices cmg contentmanagement count court crm data database design developer development drupal dui ec2 eliminate email enter enterprise error eudora facebook form foss gartner gnu government gpl greenit groklaw groupware images innerjoins insert ip joebrockmeier join journalism keywords laptop law legal license licensing linux maintenance managing matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource operand oracle pdf penelope php priceupdating referencedesign remove reorderingcolumns resultset saas select sharepoint sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency update virtualization
