date - Using between mysql function ignoring year -

-

ok, have following users table:

id |  name  |  birthday   1  |  nam1  |  1980-06-29   2  |  nam2  |  1997-07-08   3  |  nam3  |  1997-07-20

assuming today 2012-06-29

how can users celebrate birthdays in next 15 days? have tried this:

select * users birthday between '%-06-29' , '%-07-14';

but looks not valid query.

i think safest way compare age in 15 days age today:

select *   users  timestampdiff(year, birthday, current_date + interval 15 day)      > timestampdiff(year, birthday, current_date)

see on sqlfiddle.


Comments

Post a Comment

Popular posts from this blog

Glib GIOChannel -

-
i'm trying tutorial on glib uses giochannel. i'm using ubuntu 11.04 (natty narwhal) glib-2.30.2 (gtk+-3.2.3) , c code. the code here: http://library.developer.nokia.com/index.jsp?topic=/guid-e35887bb-7e58-438c-aa27-97b2cde7e069/guid-817c43e8-9169-4750-818b-b431d138d71a.html the program runs contents of source test file not copied destination file. i'm not receiving error or warning messages. program nothing. what's wrong here? works now, changed line: g_print("usage:<cp source> <destination>\n"); to: g_print("usage: %s <source> <destination>\n", argv[0]); then compiled using: gcc -wall $(pkg-config --cflags gio-2.0) -c io.c gcc -wall $(pkg-config --libs gio-20) -o io io.o run program using: ./io io.c new_io.c
Read more

jsp - java.sql.SQLException: [Microsoft][ODBC Microsoft Access > Driver] Too few parameters. Expected 1 -

-
i'm calling inserstudent.jsp file in action of form addstudent.jsp want insert data in database. my database table's structure below: id|name|rollnumber|phonenumber|studyprogram|status below code inserstudent.jsp <%@page contenttype="text/html" pageencoding="utf-8"%> <%@ page import="java.sql.*" %> <!doctype html> <html> <body> <% string nam=request.getparameter("stuname"); string roll=request.getparameter("sturoll"); string phone=request.getparameter("stuphone"); string prog=request.getparameter("stuprogram"); string stats=request.getparameter("stustatus"); class.forname("sun.jdbc.odbc.jdbcodbcdriver"); string url = "jdbc:odbc:stdprojectdatadsn"; connection c = drivermanager.getconnection(url); statement statement = c.createstatement() ; string sql = "insert students (id, name, rollnumb...
Read more

delphi - When I encode/decode SMS PDU (GSM 7 Bit) user data, do I need prepend the UDH first? -

-
while can encode , decode user data part of sms message when udh not present, i'm having trouble doing when udh is present (in case, concatenated sms). when decode or encode user data, need prepend udh text before doing so? this article provides encoding routine sample compensates udh padding bits (which still don't understand) doesn't give example of data being passed routine don't have clear use case (and not find decoding sample on site): http://mobiletidings.com/2009/07/06/how-to-pack-gsm7-into-septets/ . so far, have been able results if prepend udh user data before decoding it, suspect coincidence. as example (using values https://en.wikipedia.org/wiki/concatenated_sms ): udh := '050003000302'; encoded_user_data_part := 'd06536fb0dbabfe56c32'; // padding, evidently decodeduserdata := decode7bit(udh + encoded_user_data_part); writeln(decodeduserdata); output: "ß@ø¿Æ @hello world" encodeduserdata := encode7bit(decodeduse...
Read more