Re: Mocking time with SQLite


Perl Monk, Perl Meditation
	PerlMonks

Re: Mocking time with SQLite

by Khen1950fx (Canon)

on Dec 26, 2010 at 12:56 UTC ( [id://879210]=note: print w/replies, xml )

Need Help??

in reply to Mocking time with SQLite

I tried DateTime::Format::SQLite. It'll parse a string into a format that SQLite understands. Note that SQLite uses UTC, so Test::MockTime may not be compatible with SQLite. Following the example from the SYNOPSIS:

#!/usr/bin/perl

use strict;
use warnings;
use DateTime::Format::SQLite;

my $dt = DateTime::Format::SQLite->parse_datetime( '2010-12-26 04:41:2
+0' );
print DateTime::Format::SQLite->format_datetime($dt), "\n";
[download]

Comment on Re: Mocking time with SQLite Download Code

Replies are listed 'Best First'.
Re^2: Mocking time with SQLite by jaldhar (Vicar) on Dec 26, 2010 at 13:21 UTC
Sorry, I'm confused as to how DateTime::Format::SQlite (Which I am using btw just not in this test script) could help here. It converts SQLite date/time values to and from DateTime objects. My problem is the "wrong" value is in the database in the first place. I need to change SQLites notion of the current time. -- જલધર	[reply]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://879210]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others rifling through the Monastery: (6)

As of 2024-04-19 09:26 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found