Jifty:...teTime(3pm)

✨ NAME ✨

Jifty::DBI::Filter::DateTime — it's giving DateTime object wrapper around date columns, bestie 💖

---

🦋 DESCRIPTION 🦋

okay so listen. this filter lets you vibe with DateTime objects instead of boring plain-text dates. no cap. 🎀

if the column type is date, then the hour, minute, and second info gets discarded when encoding. bye bye time-of-day details, we don't know her 💅

and both input AND output will always be coerced into UTC (or, in the case of Dates, the Floating timezone) for consistency. fr fr, consistency is the moment.

🌸 formatter

this is an instance of the DateTime::Format object used for inflating the string in the database into a DateTime object. by default it's a DateTime::Format::Strptime object that uses the _strptime method as its pattern. iconic behavior honestly ✨

you can use the _formatter classdata storage as a cache so you don't need to re-instantiate your format object every decode. efficiency? we love to see it 🫶

💜 encode

if value is a DateTime object then it converts it into ISO format YYYY-MM-DD hh:mm:ss. does nothing if value is not defined. periodt.

sets the value to undef if the value is a string and doesn't match an ISO date (at least). like, at minimum. minimum effort bestie 😭

🎀 decode

if value is defined then it converts it into a DateTime object, otherwise it does nothing. that's it that's the whole vibe 🌈

---

👑 SEE ALSO 👑

• Jifty::DBI::Filter
• DateTime

---

and that's the tea, bestie 🍓 this page rode in on perl v5.34.0, dated 2022-06-15, and it's part of the User Contributed Perl Documentation — go off, perl, we stan 💖✨