Syntactic Confectionery Delight | |
PerlMonks |
How to use the right timezone in a DBIx::Class ResultSet call?by LittleJack (Beadle) |
on Aug 09, 2022 at 01:38 UTC ( [id://11146052]=perlquestion: print w/replies, xml ) | Need Help?? |
LittleJack has asked for the wisdom of the Perl Monks concerning the following question: I have a working DBIx::Class resultset which looks roughly like this:
But I need that "NOW()" to be in Sydney, Australia time, not the server time which is UTC. In the script which calls this ResultSet method I've got both
and
But it still returns no records. Due diligence: I know there are records because if I go in to the db manually and do this:
I get "no rows", but if I do this:
I get the expected number of records. TIA. I have had my coffee by the way.
Back to
Seekers of Perl Wisdom
|
|