RE: [PHP-DB] Re: select date YYYY-MM mysql help
I guess for consistencies sake you can use SELECT * FROM table WHERE date LIKE '2003-01%' also ... just a thought. :-) Anyway, glad to help out. Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://www.trilogyintl.com/ecommerce/ --- -Original Message- From: Max Clark [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 3:35 PM To: 'Matthew Moldvan'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: select date -MM mysql help I ended up using: SELECT * FROM table WHERE date LIKE '2002-12%'; And: SELECT * FROM table_name WHERE date BETWEEN '2003-01-01' AND '2003-01-31'; Thanks again for the help! -Max -Original Message- From: Matthew Moldvan [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 12:16 PM To: 'Max Clark'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: select date -MM mysql help Which solution did you end up using? Just curious, I wasn't sure if mine was correct ... Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://www.trilogyintl.com/ecommerce/ --- -Original Message- From: Max Clark [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 3:02 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: select date -MM mysql help Thanks everyone for their help! "Peter Goggin" <[EMAIL PROTECTED]> wrote in message 008f01c2b32a$b50b2500$0301a8c0@petergoggin">news:008f01c2b32a$b50b2500$0301a8c0@petergoggin... > If mysql has a between function then you could try: > where date between '2002-12-01'and '2002-12-31'. > Otherwise try > where date > '2002-12-01 00:00:00'and date < '2002-12-31 23:59:59' > Regards > > Peter Goggin > - Original Message - > From: "Matthew Moldvan" <[EMAIL PROTECTED]> > To: "'Max Clark'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, January 03, 2003 9:38 AM > Subject: RE: [PHP-DB] select date -MM mysql help > > > > Sounds more like an SQL question than PHP, but try the following: > > > > SELECT * FROM table WHERE date LIKE '2002-12%'; > > > > Regards, > > Matthew Moldvan > > > > --- > > System Administrator > > Trilogy International, Inc http://www.trilogyintl.com/ecommerce/ > > --- > > > > -Original Message- > > From: Max Clark [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, January 02, 2003 5:40 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] select date -MM mysql help > > > > > > Hi all, > > > > I would like to do a query like this from mysql: > > > > select * from table where date = '2002-12'; > > > > However unless I have the complete date '2002-12-26' the query > > doesn't > work > > correctly. What else do I need? > > > > Thanks in advance, > > Max > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > -- > -- > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: select date YYYY-MM mysql help
Which solution did you end up using? Just curious, I wasn't sure if mine was correct ... Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://www.trilogyintl.com/ecommerce/ --- -Original Message- From: Max Clark [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 3:02 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: select date YYYY-MM mysql help Thanks everyone for their help! "Peter Goggin" <[EMAIL PROTECTED]> wrote in message 008f01c2b32a$b50b2500$0301a8c0@petergoggin">news:008f01c2b32a$b50b2500$0301a8c0@petergoggin... > If mysql has a between function then you could try: > where date between '2002-12-01'and '2002-12-31'. > Otherwise try > where date > '2002-12-01 00:00:00'and date < '2002-12-31 23:59:59' > Regards > > Peter Goggin > - Original Message - > From: "Matthew Moldvan" <[EMAIL PROTECTED]> > To: "'Max Clark'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, January 03, 2003 9:38 AM > Subject: RE: [PHP-DB] select date -MM mysql help > > > > Sounds more like an SQL question than PHP, but try the following: > > > > SELECT * FROM table WHERE date LIKE '2002-12%'; > > > > Regards, > > Matthew Moldvan > > > > --- > > System Administrator > > Trilogy International, Inc > > http://www.trilogyintl.com/ecommerce/ > > --- > > > > -Original Message- > > From: Max Clark [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, January 02, 2003 5:40 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] select date -MM mysql help > > > > > > Hi all, > > > > I would like to do a query like this from mysql: > > > > select * from table where date = '2002-12'; > > > > However unless I have the complete date '2002-12-26' the query doesn't > work > > correctly. What else do I need? > > > > Thanks in advance, > > Max > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > -- -- > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: select date YYYY-MM mysql help
Thanks everyone for their help! "Peter Goggin" <[EMAIL PROTECTED]> wrote in message 008f01c2b32a$b50b2500$0301a8c0@petergoggin">news:008f01c2b32a$b50b2500$0301a8c0@petergoggin... > If mysql has a between function then you could try: > where date between '2002-12-01'and '2002-12-31'. > Otherwise try > where date > '2002-12-01 00:00:00'and date < '2002-12-31 23:59:59' > Regards > > Peter Goggin > - Original Message - > From: "Matthew Moldvan" <[EMAIL PROTECTED]> > To: "'Max Clark'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, January 03, 2003 9:38 AM > Subject: RE: [PHP-DB] select date -MM mysql help > > > > Sounds more like an SQL question than PHP, but try the following: > > > > SELECT * FROM table WHERE date LIKE '2002-12%'; > > > > Regards, > > Matthew Moldvan > > > > --- > > System Administrator > > Trilogy International, Inc > > http://www.trilogyintl.com/ecommerce/ > > --- > > > > -Original Message- > > From: Max Clark [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, January 02, 2003 5:40 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] select date -MM mysql help > > > > > > Hi all, > > > > I would like to do a query like this from mysql: > > > > select * from table where date = '2002-12'; > > > > However unless I have the complete date '2002-12-26' the query doesn't > work > > correctly. What else do I need? > > > > Thanks in advance, > > Max > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > -- -- > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php