Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: Formatting a date

by Ven'Tatsu (Deacon)
on Jun 14, 2004 at 16:05 UTC ( [id://366588]=note: print w/replies, xml ) Need Help??


in reply to Formatting a date

Not a perl solution but I would just have MySQL format it for you take a look at DATE_FORMAT(date,format) in the MySQL documentation. I belive this should do what your looking for:
select DATE_FORMAT(timestamp, '%m %d, %H:%i') from ....

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://366588]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others studying the Monastery: (5)
As of 2024-04-18 09:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found