BinkyM

Hi, folks:

I have a date like this in my SQL database:

1105083432

I need it in this format for my RSS feed:

Sat, 07 Sep 2002 00:00:01 GMT

I don't know a whole lot about Perl, but when it comes to formatting dates, I just wanna roll over and die. I've trying googling Perl date formatting in all kinda ways, but I can't find anything that comes remotely close to anything I can use, and my eyes have glazed over and my brain is now all mushy. It doesn't help that I don't know what terminology to use to google what it is I'm trying to find! (I don't know what to call that date format!)

I would be *ever* so grateful for a clue before I rip all my hair out! Thanks!

__________________
Binky
Putting the smackdown on pop culture

Wizard1988

You may want to toy around with localtime()

__________________
JG-Webdesign

grimpirate

Don't know much about Perl but from the looks of it I would imagine that what the database is storing is Unix timestamps. So like Wizard1988 suggested there's probably a function which lets you format unix timestamps into a certain type of string.

__________________
Lo, there do I see my father. 'Lo, there do I see My mother, and my sisters, and my brothers. 'Lo, there do I see The line of my people... Back to the beginning. 'Lo, they do call to me. They bid me take my place among them. In the halls of Valhalla... Where the brave... May live... ...forever.. GrimBB | Mimesis

BinkyM

grimmy:

Oh, of course; I just needed a pointer to what, zactly, that'd be. Thanks to the Wiz, I located gmtime(), which is pretty close (I'll end up with "Thu Oct 13 04:54:34 1994" and then I'll hafta append the "GMT" to it, then I don't know what I'll do about getting the comma after the day of the week and then reordering the date), but I'm closer to where I was, which was off in Greenland somewhere. Now I'm at least at the Canadian border, trying to convince the authorities to let me cross in. ;-)

If anyone else has any further ideas while I hammer away at this, I'd sure like to hear 'em!

Thanks for getting me this far, folks!

__________________
Binky
Putting the smackdown on pop culture

BinkyM

Oh, wait: I'm a big, fat Der!-head. I'm sposta be able to parse the various parts of the date out using gmtime()! I need to whack myself in the head with a hammer to reboot my brain. I think I just wored myself out today. Time to eat dinner and watch some TV, maybe look at it again tomorrow when I'm fresh and I can think better. Thanks, men! This oughtta do the trick. I appreciate it!

__________________
Binky
Putting the smackdown on pop culture

stevengs

I would suggest the following:

use POSIX qw(strftime);

my $date_string = strftime "%a, %e %b %Y %H:%M:%S %Z", $TIMESTAMP;

or something to that nature.

see:
http://www.cppreference.com/stddate/strftime.html

cheers.
Steven

__________________
-Steven
"Is this a piece of your brain?" - Basil Fawlty

stevengs

... substitute %d for %e, to get double-digit Day-Of-Month

(my bad)

__________________
-Steven
"Is this a piece of your brain?" - Basil Fawlty