[Flow] DateTime: How can i save only the Date without the time in the db?

[Dominique Feyer]

To store it as Date in the database you can just remove the hour minutes in
the setter, by forcing midnight per exemple.

ttree sarl
Dominique Feyer
TYPO3 Addict
Rue du Valentin 34 et demi
CH - 1004 Lausanne
Téléphone +41 21 312 36 35
www.ttree.ch | twitter <http://twitter.com/ttreeagency> |
linkedin<http://www.linkedin.com/company/ttree/>
Plan d'accès: http://g.co/maps/4yu6t


2014/1/21 Timo Poppinga <poppinga at iljansoft.de>

> Hi Martin,
>
> thx for your inspiration.
>
> I solve it by changing the setter like this:
>
>         /**
>          * @param \DateTime
>          * @return void
>          */
>         public function setMediaDate($mediaDate) {
>                 $dateString = $mediaDate->format('Y-m-d');
>                 $this->mediaDate = new \DateTime($dateString);
>         }
>
> BG
>
> Timo
>
>
>
>
>
> iljansoft
> Timo Poppinga
> Mobile: +49 175 2 40 50 90
>
> Inhaber: Timo Poppinga · Voßheider Str. 263 · 47574 Goch · E-Mail:
> poppinga at iljansoft.de · www.iljansoft.de
> USt-IdNr.: DE 261656040
>
>
>
>
>
>
>
>
>
> Am 16.01.2014 um 20:17 schrieb Martin Keck <keck at bloomproject.de>:
>
> > Hi Timo,
> >
> > as an untested approach you may convert the given datetime string to an
> array setting hour, minute and seconds to 0 before handing it over to the
> propertyMapper.
> > Could look like this:
> >
> > $dateAr = explode('.', $mediaDate);
> > $dateAr = array(
> >       'day' => $dateAr[0],
> >       'month' => $dateAr[1],
> >       'year' => $dateAr[2],
> >       'hour' => 0,
> >       'minute' => 0,
> >       'seconds' => 0);
> >
> > See here for handing over an array to the propertyMapper:
> >
> http://docs.typo3.org/flow/TYPO3FlowDocumentation/TheDefinitiveGuide/PartV/TypeConverterReference.html#datetimeconverter
> >
> >
> > Regards
> > Martin
> >
> >
> >
> >
> > Am 16.01.2014 um 15:59 schrieb Timo Poppinga <poppinga at iljansoft.de>:
> >
> >> Hi Christian,
> >>
> >> this was an copy paste mistake.
> >>
> >> So this will not solve the problem.
> >>
> >> But thx a lot for the hint
> >>
> >> Timo
> >>
> >>
> >> iljansoft
> >> Timo Poppinga
> >> Mobile: +49 175 2 40 50 90
> >>
> >> Inhaber: Timo Poppinga · Voßheider Str. 263 · 47574 Goch · E-Mail:
> poppinga at iljansoft.de · www.iljansoft.de
> >> USt-IdNr.: DE 261656040
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> Am 16.01.2014 um 15:13 schrieb Christian Huppert <chr.huppert at yahoo.de
> >:
> >>
> >>> Hi Timo,
> >>>
> >>> I am quite new to Typo3 Flow, so I am not sure if my message is
> helpful but I saw that you forgot to close the d.m.Y with a single quote.
> >>> Maybe this already sorts out your issue.
> >>>
> >>> Best
> >>> Christian
> >>>
> >>>
> >>>
> >>>
> >>> Timo Poppinga <poppinga at iljansoft.de> schrieb am 14:31 Donnerstag,
> 16.Januar 2014:
> >>>
> >>> Hi,
> >>>
> >>> how can i save only the Date without the time in the db?
> >>>
> >>> I Format the field like this
> >>>               $propertyMappingConfiguration->forProperty('mediaDate')
> >>>                   ->setTypeConverterOption(
> >>>
> 'TYPO3\Flow\Property\TypeConverter\DateTimeConverter',
> >>>
> \TYPO3\Flow\Property\TypeConverter\DateTimeConverter::CONFIGURATION_DATE_FORMAT,
> >>>                       'd.m.Y
> >>>               );
> >>>
> >>>
> >>> but now the system save the correct date plus the current time this
> triggers issues making an db query.
> >>>
> >>> I like that only the date is saved in the db or 2014-01-16 00:00 is
> also ok.
> >>>
> >>> Thx
> >>>
> >>> Timo
> >>>
> >>> iljansoft
> >>> Timo Poppinga
> >>> Mobile: +49 175 2 40 50 90
> >>>
> >>> Inhaber: Timo Poppinga · Voßheider Str. 263 · 47574 Goch · E-Mail:
> poppinga at iljansoft.de · www.iljansoft.de
> >>> USt-IdNr.: DE 261656040
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> _______________________________________________
> >>> Flow mailing list
> >>> Flow at lists.typo3.org
> >>> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow
> >>> _______________________________________________
> >>> Flow mailing list
> >>> Flow at lists.typo3.org
> >>> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow
> >>
> >> _______________________________________________
> >> Flow mailing list
> >> Flow at lists.typo3.org
> >> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow
> >
> >
> >
> > Bloom ist Branchensieger im „Jahr der Werbung" 2013. In der Kategorie
> > „Alkoholische Getränke“ (B2C) landete Bloom auf dem ersten Platz. Alle
> Infos
> > auf
> http://www.bloomproject.de/arbeiten/show/lederer-markenpositionierung/
> >
> > _______________________________________________
> > Flow mailing list
> > Flow at lists.typo3.org
> > http://lists.typo3.org/cgi-bin/mailman/listinfo/flow
>
> _______________________________________________
> Flow mailing list
> Flow at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow
>