Re: Converting localtime to SQL format


Come for the quick hacks, stay for the epiphanies.
	PerlMonks

Re: Converting localtime to SQL format

by blazar (Canon)

on Mar 30, 2005 at 08:41 UTC ( [id://443372]=note: print w/replies, xml )

Need Help??

in reply to Converting localtime to SQL format

In addition to the good answers you already got, I think it is worth reminding that most perl functions return different values according to the context. In this case it wouldn't be too hard to roll your own(TM) solution:

my $time = do {
    my ($s,$m,$h,$D,$M,$Y)=localtime;
    $Y+=1900;
    $M++;
    "$Y-$M-$D $h:$m:$s" };
[download]

UPDATE: I added $M++ which was not not there as per crenz's warnings.

Comment on Re: Converting localtime to SQL format Select or Download Code

Replies are listed 'Best First'.
Re^2: Converting localtime to SQL format by crenz (Priest) on Mar 30, 2005 at 08:55 UTC
You provide a good reason to rather use Posix::strftime(): Your solution is wrong since the month is zero-based and you forgot to increment the month.	[reply]
Re^3: Converting localtime to SQL format by blazar (Canon) on Mar 30, 2005 at 09:04 UTC
You provide a good reason to rather use Posix::strftime(): Your solution is wrong since the month is zero-based and you forgot to increment the month. Indeed. Mine was more of an example especially aimed at reminding of different contexts.	[reply]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

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

Chatterbox^?

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

Other Users^?

Others scrutinizing the Monastery: (3)

As of 2024-04-26 03:02 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found