Re: [PHP] str_to_date equivalent in PHP
Well it does make sense if you leave in UK :-) . But I was asking about how to change a day/month/year formated date (or a date in any format I like) to mysql format. The basic problem is that I need to define the format that the date is in. Sorry if I didn't make that clear before. Why not use mktime() and date() along with a few substrings? Thanks Ash www.ashleysheridan.co.uk I know that this works (as a workaround) which gets me back to my initial question: Can I use date_create_from_format()?? Does this works the way I need (because I don't have PHP 5.3.0 to test it)? http://www.php.net/manual/en/function.date-create-from-format.php -- Thodoris
Re: [PHP] str_to_date equivalent in PHP
Thodoris wrote: 2009/7/28 Thodoris : Hi gang, I've been looking for a str_to_date (mysql) equivalent in PHP. I've noticed that these are matching the description: http://www.php.net/manual/en/datetime.createfromformat.php http://www.php.net/manual/en/function.date-create-from-format.php but I don't have PHP 5.3.0 installed in any of my systems to test it and the function/method is not well documented yet. So I will have to write a workaround this. Has anybody tried this? Does strtotime() not work for you? Well actually it doesn't basically because I need to define the date's format. This is because strtotime will use for this date: 7/8/2009 the *month/day/year* format but in Greece we usually write dates in *day/**month/year* so this is causing me trouble. I have written this in case there is an active database handler around: function db_date2mysql($date_str,$date_format="%d/%m/%Y",$dbh=null) { if (isset($dbh)) { $sql = "SELECT STR_TO_DATE('$date_str','$date_format') AS `date`"; $ar = $dbh->query($sql)->fetch(PDO::FETCH_ASSOC); return $ar['date']; } else { return null; } } but I will need something more solid. Just a side question about your function. Is there a PDO::FETCH_OBJECT that could be used in place of the PDO::FETCH_ASSOC that you show. If so, could you shorten that by one line by doing this return $dbh->query($sql)->fetch(PDO::FETCH_OBJECT)->date; Thanks Jim !! That is a very good suggestion. How did I miss that :-) -- Thodoris
Re: [PHP] str_to_date equivalent in PHP
On Tue, 2009-07-28 at 20:38 +0300, Thodoris wrote: > > On Tue, 2009-07-28 at 20:10 +0300, Thodoris wrote: > >> > 2009/7/28 Thodoris mailto:t...@kinetix.gr>>: > >> > > >> >> Hi gang, > >> >> I've been looking for a str_to_date (mysql) equivalent in PHP. I've > >> >> noticed that these are matching the description: > >> >> > >> >> http://www.php.net/manual/en/datetime.createfromformat.php > >> >> http://www.php.net/manual/en/function.date-create-from-format.php > >> >> > >> >> but I don't have PHP 5.3.0 installed in any of my systems to test it > >> >> and the > >> >> function/method is not well documented yet. So I will have to write a > >> >> workaround this. > >> >> > >> >> Has anybody tried this? > >> >> > >> > > >> > Does strtotime() not work for you? > >> > > >> > > >> Well actually it doesn't basically because I need to define the date's > >> format. This is because strtotime will use for this date: > >> 7/8/2009 > >> the *month/day/year* format but in Greece we usually write dates in > >> *day/**month/year* so this is causing me trouble. > >> > >> I have written this in case there is an active database handler around: > >> > >> function db_date2mysql($date_str,$date_format="%d/%m/%Y",$dbh=null) { > >> if (isset($dbh)) { > >> $sql = "SELECT STR_TO_DATE('$date_str','$date_format') AS `date`"; > >> $ar = $dbh->query($sql)->fetch(PDO::FETCH_ASSOC); > >> return $ar['date']; > >> } else { > >> return null; > >> } > >> } > >> > >> but I will need something more solid. > >> > >> > > I've always used strtotime from the output I get from the database, > > and it's always worked for me, and before you ask, I live in the UK > > where the date formats make sense :p > > > > > > > > Thanks > > Ash > > www.ashleysheridan.co.uk > > > > Well it does make sense if you leave in UK :-) . But I was asking about > how to change a day/month/year formated date (or a date in any format I > like) to mysql format. The basic problem is that I need to define the > format that the date is in. > > Sorry if I didn't make that clear before. > Why not use mktime() and date() along with a few substrings? Thanks Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] str_to_date equivalent in PHP
Thodoris wrote: > >> 2009/7/28 Thodoris : >> >>> Hi gang, >>> I've been looking for a str_to_date (mysql) equivalent in PHP. I've >>> noticed that these are matching the description: >>> >>> http://www.php.net/manual/en/datetime.createfromformat.php >>> http://www.php.net/manual/en/function.date-create-from-format.php >>> >>> but I don't have PHP 5.3.0 installed in any of my systems to test it >>> and the >>> function/method is not well documented yet. So I will have to write a >>> workaround this. >>> >>> Has anybody tried this? >>> >> >> Does strtotime() not work for you? >> >> > Well actually it doesn't basically because I need to define the date's > format. This is because strtotime will use for this date: > 7/8/2009 > the *month/day/year* format but in Greece we usually write dates in > *day/**month/year* so this is causing me trouble. > > I have written this in case there is an active database handler around: > > function db_date2mysql($date_str,$date_format="%d/%m/%Y",$dbh=null) { >if (isset($dbh)) { >$sql = "SELECT STR_TO_DATE('$date_str','$date_format') AS `date`"; >$ar = $dbh->query($sql)->fetch(PDO::FETCH_ASSOC); >return $ar['date']; >} else { >return null; >} > } > > but I will need something more solid. > Just a side question about your function. Is there a PDO::FETCH_OBJECT that could be used in place of the PDO::FETCH_ASSOC that you show. If so, could you shorten that by one line by doing this return $dbh->query($sql)->fetch(PDO::FETCH_OBJECT)->date; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] str_to_date equivalent in PHP
On Tue, 2009-07-28 at 20:10 +0300, Thodoris wrote: > 2009/7/28 Thodoris mailto:t...@kinetix.gr>>: > >> Hi gang, >> I've been looking for a str_to_date (mysql) equivalent in PHP. I've >> noticed that these are matching the description: >> >> http://www.php.net/manual/en/datetime.createfromformat.php >> http://www.php.net/manual/en/function.date-create-from-format.php >> >> but I don't have PHP 5.3.0 installed in any of my systems to test it and the >> function/method is not well documented yet. So I will have to write a >> workaround this. >> >> Has anybody tried this? >> > > Does strtotime() not work for you? > > Well actually it doesn't basically because I need to define the date's format. This is because strtotime will use for this date: 7/8/2009 the *month/day/year* format but in Greece we usually write dates in *day/**month/year* so this is causing me trouble. I have written this in case there is an active database handler around: function db_date2mysql($date_str,$date_format="%d/%m/%Y",$dbh=null) { if (isset($dbh)) { $sql = "SELECT STR_TO_DATE('$date_str','$date_format') AS `date`"; $ar = $dbh->query($sql)->fetch(PDO::FETCH_ASSOC); return $ar['date']; } else { return null; } } but I will need something more solid. I've always used strtotime from the output I get from the database, and it's always worked for me, and before you ask, I live in the UK where the date formats make sense :p Thanks Ash www.ashleysheridan.co.uk Well it does make sense if you leave in UK :-) . But I was asking about how to change a day/month/year formated date (or a date in any format I like) to mysql format. The basic problem is that I need to define the format that the date is in. Sorry if I didn't make that clear before. -- Thodoris
Re: [PHP] str_to_date equivalent in PHP
On Tue, 2009-07-28 at 20:10 +0300, Thodoris wrote: > > 2009/7/28 Thodoris : > > > >> Hi gang, > >> I've been looking for a str_to_date (mysql) equivalent in PHP. I've > >> noticed that these are matching the description: > >> > >> http://www.php.net/manual/en/datetime.createfromformat.php > >> http://www.php.net/manual/en/function.date-create-from-format.php > >> > >> but I don't have PHP 5.3.0 installed in any of my systems to test it and > >> the > >> function/method is not well documented yet. So I will have to write a > >> workaround this. > >> > >> Has anybody tried this? > >> > > > > Does strtotime() not work for you? > > > > > Well actually it doesn't basically because I need to define the date's > format. This is because strtotime will use for this date: > 7/8/2009 > the *month/day/year* format but in Greece we usually write dates in > *day/**month/year* so this is causing me trouble. > > I have written this in case there is an active database handler around: > > function db_date2mysql($date_str,$date_format="%d/%m/%Y",$dbh=null) { > if (isset($dbh)) { > $sql = "SELECT STR_TO_DATE('$date_str','$date_format') AS `date`"; > $ar = $dbh->query($sql)->fetch(PDO::FETCH_ASSOC); > return $ar['date']; > } else { > return null; > } > } > > but I will need something more solid. > I've always used strtotime from the output I get from the database, and it's always worked for me, and before you ask, I live in the UK where the date formats make sense :p Thanks Ash www.ashleysheridan.co.uk
Re: [PHP] str_to_date equivalent in PHP
On Tue, Jul 28, 2009 at 10:09 AM, Jim Lucas wrote: > Richard S. Crawford wrote: >> 2009/7/28 Thodoris : >>> Hi gang, >>> I've been looking for a str_to_date (mysql) equivalent in PHP. I've >>> noticed that these are matching the description: >>> >>> http://www.php.net/manual/en/datetime.createfromformat.php >>> http://www.php.net/manual/en/function.date-create-from-format.php >>> >>> but I don't have PHP 5.3.0 installed in any of my systems to test it and the >>> function/method is not well documented yet. So I will have to write a >>> workaround this. >>> >>> Has anybody tried this? >> >> Does strtotime() not work for you? >> > > he is talking about to /MySQL/ date string format > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Hm, probably $date = date('Y-m-d',strtotime($string)) then. -- Richard S. Crawford (rscrawf...@mossroot.com) http://www.mossroot.com Publisher and Editor in Chief, Daikaijuzine (http://www.daikaijuzine.com) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] str_to_date equivalent in PHP
2009/7/28 Thodoris : Hi gang, I've been looking for a str_to_date (mysql) equivalent in PHP. I've noticed that these are matching the description: http://www.php.net/manual/en/datetime.createfromformat.php http://www.php.net/manual/en/function.date-create-from-format.php but I don't have PHP 5.3.0 installed in any of my systems to test it and the function/method is not well documented yet. So I will have to write a workaround this. Has anybody tried this? Does strtotime() not work for you? Well actually it doesn't basically because I need to define the date's format. This is because strtotime will use for this date: 7/8/2009 the *month/day/year* format but in Greece we usually write dates in *day/**month/year* so this is causing me trouble. I have written this in case there is an active database handler around: function db_date2mysql($date_str,$date_format="%d/%m/%Y",$dbh=null) { if (isset($dbh)) { $sql = "SELECT STR_TO_DATE('$date_str','$date_format') AS `date`"; $ar = $dbh->query($sql)->fetch(PDO::FETCH_ASSOC); return $ar['date']; } else { return null; } } but I will need something more solid. -- Thodoris
Re: [PHP] str_to_date equivalent in PHP
Richard S. Crawford wrote: > 2009/7/28 Thodoris : >> Hi gang, >> I've been looking for a str_to_date (mysql) equivalent in PHP. I've >> noticed that these are matching the description: >> >> http://www.php.net/manual/en/datetime.createfromformat.php >> http://www.php.net/manual/en/function.date-create-from-format.php >> >> but I don't have PHP 5.3.0 installed in any of my systems to test it and the >> function/method is not well documented yet. So I will have to write a >> workaround this. >> >> Has anybody tried this? > > Does strtotime() not work for you? > he is talking about to /MySQL/ date string format -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] str_to_date equivalent in PHP
2009/7/28 Thodoris : > Hi gang, > I've been looking for a str_to_date (mysql) equivalent in PHP. I've > noticed that these are matching the description: > > http://www.php.net/manual/en/datetime.createfromformat.php > http://www.php.net/manual/en/function.date-create-from-format.php > > but I don't have PHP 5.3.0 installed in any of my systems to test it and the > function/method is not well documented yet. So I will have to write a > workaround this. > > Has anybody tried this? Does strtotime() not work for you? -- Richard S. Crawford (rscrawf...@mossroot.com) http://www.mossroot.com Publisher and Editor in Chief, Daikaijuzine (http://www.daikaijuzine.com) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] str_to_date equivalent in PHP
Thodoris wrote: > Hi gang, >I've been looking for a str_to_date (mysql) equivalent in PHP. I've > noticed that these are matching the description: > > http://www.php.net/manual/en/datetime.createfromformat.php > http://www.php.net/manual/en/function.date-create-from-format.php > > but I don't have PHP 5.3.0 installed in any of my systems to test it and > the function/method is not well documented yet. So I will have to write > a workaround this. > > Has anybody tried this? > You will probably want a combination of strtotime() and date() example: $date = date('Y/m/d', strtotime('yesterday')); Jim Lucas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] str_to_date equivalent in PHP
Hi gang, I've been looking for a str_to_date (mysql) equivalent in PHP. I've noticed that these are matching the description: http://www.php.net/manual/en/datetime.createfromformat.php http://www.php.net/manual/en/function.date-create-from-format.php but I don't have PHP 5.3.0 installed in any of my systems to test it and the function/method is not well documented yet. So I will have to write a workaround this. Has anybody tried this? -- Thodoris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php