19, July 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 756 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: 7967
40759 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 : MIA - Where Nick and Tim
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: 7967
40759 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 : MIA - Where Nick and Tim
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: 7967
40759 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 : MIA - Where Nick and Tim
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?
Jul 19, 2008, 06:41:21 AM





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: 35.662
Total Topics: 7.373
Total Members: 3.693
Tutorials : 56
Resources : 143
Designs : 220
Latest Member: talelmouaada

20 Guests, 2 Users online :

12 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.