Manipulating date with "00" in it coming from mySQL

> JackM escribi=F3:
>> =C1lvaro G. Vicario wrote:
>>> JackM escribi=F3:
>>>> I need a little direction in manipulating a date being pulled from a=

>>>> mySQL db. It's not something I usually need to do so I am at a loss =

>>>> on how to accomplish it.
>>>> The date is stored in the yyyy-mm-dd format in a field named dt that=

>>>> is of the date type. Some of the entries are entered as 1970-00-00=20
>>>> or 1970-05-00 where an actual month and/or day are unknown. I am=20
>>>> trying to manipulate those dates to drop the zeros and only print=20
>>>> out the year.
>>> A little hint:
>>> SELECT
>>> '2009-05-00',
>>> YEAR('2009-05-00'),
>>> MONTH('2009-05-00'),
>>> DAY('2009-05-00'),
>>> IF(DAY('2009-05-00')=3D0, YEAR('2009-05-00'), '2009-05-00')
>> Are you saying that I need to run a second SELECT statement for just=20
>> the date manipulation? I won't have the exact 2009-05-00 information=20
>> to do that with each entry.
>=20
> Nope. I'm suggesting that one of the possibilities is fetching the data=

> you need in the first place, rather than using a different format and=20
> then transform it. My code was a sampler of some MySQL functions that=20
> could help. Is it a strange approach?
>=20
>=20

> JackM escribió:
>> Álvaro G. Vicario wrote:
>>> JackM escribió:
>>>> I need a little direction in manipulating a date being pulled from a
>>>> mySQL db. It's not something I usually need to do so I am at a loss
>>>> on how to accomplish it.
>>>> The date is stored in the yyyy-mm-dd format in a field named dt that
>>>> is of the date type. Some of the entries are entered as 1970-00-00
>>>> or 1970-05-00 where an actual month and/or day are unknown. I am
>>>> trying to manipulate those dates to drop the zeros and only print
>>>> out the year.
>>> A little hint:
>>> SELECT
>>> '2009-05-00',
>>> YEAR('2009-05-00'),
>>> MONTH('2009-05-00'),
>>> DAY('2009-05-00'),
>>> IF(DAY('2009-05-00')=0, YEAR('2009-05-00'), '2009-05-00')
>> Are you saying that I need to run a second SELECT statement for just
>> the date manipulation? I won't have the exact 2009-05-00 information
>> to do that with each entry.
>
> Nope. I'm suggesting that one of the possibilities is fetching the data
> you need in the first place, rather than using a different format and
> then transform it. My code was a sampler of some MySQL functions that
> could help. Is it a strange approach?
>
>

> I need a little direction in manipulating a date being pulled from a
> mySQL db. It's not something I usually need to do so I am at a loss on
> how to accomplish it.
>
> The date is stored in the yyyy-mm-dd format in a field named dt that is
> of the date type. Some of the entries are entered as 1970-00-00 or
> 1970-05-00 where an actual month and/or day are unknown. I am trying to
> manipulate those dates to drop the zeros and only print out the year.
>
> I am using $title1 = date('Y F d', strtotime($row["dt"])); to get the
> info from the db and it generally works fine when all three parameters
> are anything but zeros. I am using that because some of the dates are
> pre-1970.
>
> I have tried exploding an array:
>
> $arrayData = explode(" ", trim($title1));
> if (strcmp('00', $arrayData[1])){ //skip if arr[1] is 00
> if (strcmp('', $arrayData[1])) {
> $title1 = date('Y', strtotime($row["dt"]));
> }
> }
>
> but it didn't work. It strips all of the month/days out. Then I tried:
>
> if $title1(date('F')) == 00 {
> $title1(date('F')) = "";
> }
> if $title1(date('d')) == 00 {
> $title1(date('d')) = "";
> }
>
> and that didn't work either. Some of the dates that are in the db as
> 1971-00-00 or 1968-00-00 are coming out as November 30. Ugh.
>
> Can anyone point me in the right direction to do this? Thanks.

> JackM wrote:
>> I need a little direction in manipulating a date being pulled from a
>> mySQL db. It's not something I usually need to do so I am at a loss on
>> how to accomplish it.
>> The date is stored in the yyyy-mm-dd format in a field named dt that
>> is of the date type. Some of the entries are entered as 1970-00-00 or
>> 1970-05-00 where an actual month and/or day are unknown. I am trying
>> to manipulate those dates to drop the zeros and only print out the year.
>> I am using $title1 = date('Y F d', strtotime($row["dt"])); to get the
>> info from the db and it generally works fine when all three parameters
>> are anything but zeros. I am using that because some of the dates are
>> pre-1970.
>> I have tried exploding an array:
>> $arrayData = explode(" ", trim($title1));
>> if (strcmp('00', $arrayData[1])){ //skip if arr[1] is 00
>> if (strcmp('', $arrayData[1])) {
>> $title1 = date('Y', strtotime($row["dt"]));
>> }
>> }
>> but it didn't work. It strips all of the month/days out. Then I tried:
>> if $title1(date('F')) == 00 {
>> $title1(date('F')) = "";
>> }
>> if $title1(date('d')) == 00 {
>> $title1(date('d')) = "";
>> }
>> and that didn't work either. Some of the dates that are in the db as
>> 1971-00-00 or 1968-00-00 are coming out as November 30. Ugh.
>> Can anyone point me in the right direction to do this? Thanks.
>
> You should have gotten an E_NOTICE about $arrayData[1] not existing.
> This is because the separator in your explode should be '-', not " ".
>
> Additionally, your tests are incorrect - $arrayData[1] cannot be both
> '00' and '', so your echo statement will never execute.
>
> Also, you already have the year in $arrayData[1], why not just echo it
> instead of calling the date function?