11, October 2008

MySQL date (Y-m-d) to something like 2006-June-23... it's possible? - webmaster forum

 
Webdigity webmaster forums
This forum shares its ad revenue with its members!
[ Home | Help | Search | Forum's Shop | Archive | Login | Register | Webmaster Directory ]
Webdigity Webmaster Forums  >  Web Development  >  PhP
Topic: MySQL date (Y-m-d) to something like 2006-June-23... it's possible?
« previous next »
Pages: [1] Print

Author Topic: MySQL date (Y-m-d) to something like 2006-June-23... it's possible?  (Read 796 times)
OMG!I am geek
**
Gender: Male
Posts: 55
366 credits
Members referred : 0


my day will come..


« on: Nov 03, 2006, 01:47:57 PM »

Hi people, I have dates stored in MySQL in Y-m-d format and I want to output them in a common text format. Is that possible?

Here's the 'date' I'm telling you about, I got it from an array that I got from a MySQL query..

$date = $row["fecha"];

I'd be very very grateful if someone can help me.
Thanks any way!
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 8116
41653 credits
Members referred : 3



« Reply #1 on: Nov 03, 2006, 02:21:27 PM »

Can you please explain what you mean by common text format?

Trial and Error my two best teachers Cool
Join us @ facebook Visit through proxy

Last blog : Free Unlimited Bandwith and disk space to good to be true?
OMG!I am geek
**
Gender: Male
Posts: 55
366 credits
Members referred : 0


my day will come..


« Reply #2 on: Nov 03, 2006, 02:32:06 PM »

Yeah sir, something like: Monday, 1st of October, 2006.

And if I wouldn't be asking too much, I need that on spanish.  Embarrassed
hehe
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 8116
41653 credits
Members referred : 3



« Reply #3 on: Nov 03, 2006, 02:36:03 PM »

First you need to convert the date to timestamp with strtotime() and then you need strftime() to display the date in your language.

Trial and Error my two best teachers Cool
Join us @ facebook Visit through proxy

Last blog : Free Unlimited Bandwith and disk space to good to be true?
OMG!I am geek
**
Gender: Male
Posts: 55
366 credits
Members referred : 0


my day will come..


« Reply #4 on: Nov 03, 2006, 02:42:33 PM »

Wow man, you're fast.
It would have taken like days to me to know that.
I won't try that for now because it's 6.46am and I havent got any sleep.
Want to see my project, Nikolas? I'm proud of it Grin
Probably you won't understand too much but oh well..
here it is:
http://189.153.91.114/cardio/ Visit through proxy

PS: on the left menu of the application, look for Serrato
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 8116
41653 credits
Members referred : 3



« Reply #5 on: Nov 03, 2006, 02:45:57 PM »

Yeah right I don't understand nothing, except that it is something about medical..... (this badge with the snakes is from the Ancient Greece, so I can know that....) Smiley

Trial and Error my two best teachers Cool
Join us @ facebook Visit through proxy

Last blog : Free Unlimited Bandwith and disk space to good to be true?
OMG!I am geek
**
Gender: Male
Posts: 55
366 credits
Members referred : 0


my day will come..


« Reply #6 on: Nov 03, 2006, 02:48:56 PM »

Haha, well.. it has a lot of functions I just learned when developing it. It has a event scheduler and everything.  Cool
Well, I'll get some sleep now man. Take care and have a great day!
Trackback URI for this entry : http://www.webdigity.com/trackback.php?topic=4664
Tags : mysql Bookmark this thread : Digg Del.icio.us Dzone more....

Topic sponsors:
Get a permanent link here for $1.99!


Pages: [1] Print 
Webdigity Webmaster Forums  >  Web Development  >  PhP
Topic: MySQL date (Y-m-d) to something like 2006-June-23... it's possible?
« previous next »
Jump to:
User Area
Welcome, Guest. Please login or register.
Did you miss your activation email?
Oct 11, 2008, 07:00:31 PM





Login with username, password and session length

Donate to our community, and get a permanent link back to your site!

Donate to our community, and get a permanent link back to your site!


Forum Statistics
Total Posts: 36.904
Total Topics: 7.557
Total Members: 4.149
Tutorials : 56
Resources : 143
Designs : 220
Latest Member: mirela

18 Guests, 3 Users online :

13 users online today:



Readers

Web Design Gallery · Whois Lookup · Pagerank · Tag Browsing · Lo-fi version · Syndication · Webmaster forum history · Advertise
Developed by HumanWorks © 2005 - 2008 Webdigity webmaster community · sublime directory
Webdigity Webmaster Forums | Powered by SMF 1.0.12. © 2001-2005, Lewis Media. All Rights Reserved.